1. Tables and Views for HCM
  2. PAY_XLA_ESTIMATE_ACT_SRCS_V

PAY_XLA_ESTIMATE_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

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

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 in ('EC', 'ECR')