PAY_XLA_PAYMENT_ACT_SRCS_V

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
PAY_XLA_EVENT_ID COST_PROCESS_FLOW_NAME COST_PROCESS_NAME BASE_PROCESS_FLOW_NAME BASE_PROCESS_NAME

Query

SQL_Statement

SELECT PXE.EVENT_ID PAY_XLA_EVENT_ID, PAY_SLA_PKG.GET_FLOW_NAME(COST_PA.PAYROLL_ACTION_ID) COST_PROCESS_FLOW_NAME, PAY_SLA_PKG.GET_PROCESS_NAME(COST_PA.ACTION_TYPE) COST_PROCESS_NAME, PAY_SLA_PKG.PAYMENT_COST_GET_BASE_FLOW_NAME(COST_RA.PAYROLL_REL_ACTION_ID) BASE_PROCESS_FLOW_NAME, PAY_SLA_PKG.PAYMENT_COST_GET_BASE_PROCESS_NAME(COST_RA.PAYROLL_REL_ACTION_ID) BASE_PROCESS_NAME FROM PAY_XLA_EVENTS PXE, PAY_PAYROLL_REL_ACTIONS COST_RA, PAY_PAYROLL_ACTIONS COST_PA WHERE COST_RA.PAYROLL_REL_ACTION_ID = PXE.COST_ACTION_ID AND COST_PA.PAYROLL_ACTION_ID = COST_RA.PAYROLL_ACTION_ID AND PXE.COST_TYPE = 'CP'