DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on PA_PAY_ELEMENT_MAPPING

Line 367: PA_PAY_ELEMENT_MAPPING PEM

363: TIME_PERIOD_END_DATE,
364: ELEMENT_TYPE_ID
365: from
366: PA_PAY_INTERFACE_TEMP ) PIT,
367: PA_PAY_ELEMENT_MAPPING PEM
368: WHERE
369: PAA.BATCH_ID = PIT.PAYROLL_ACTION_ID
370: AND PAA.PAYROLL_ID = PIT.PAYROLL_ID
371: AND PAA.TIME_PERIOD_ID = PIT.TIME_PERIOD_ID

Line 768: Payroll data will be grouped as per the Pay Element Rule setups in PA_PAY_ELEMENT_MAPPING

764: /*
765: Procedure : LOAD_SOURCE_AMOUNTS
766: Type : Private
767: Purpose : Below procedure loads the EBS payroll data to PA_PAY_SOURCE_AMOUNTS.
768: Payroll data will be grouped as per the Pay Element Rule setups in PA_PAY_ELEMENT_MAPPING
769: and the org/project/task segment values coming from Payroll
770: Dynamic SQL is built and executed for each pay element
771: Note : Applicable only for EBS Payroll.
772: : PA_PAY_SOURCE_AMOUNTS will show the amount associates with each

Line 773: pay element and the status of the setups in PA_PAY_ELEMENT_MAPPING

769: and the org/project/task segment values coming from Payroll
770: Dynamic SQL is built and executed for each pay element
771: Note : Applicable only for EBS Payroll.
772: : PA_PAY_SOURCE_AMOUNTS will show the amount associates with each
773: pay element and the status of the setups in PA_PAY_ELEMENT_MAPPING
774: at that time when distribution was run.
775: */
776:
777: PROCEDURE load_source_amounts (P_INTERFACE_RUN_ID NUMBER,

Line 881: PA_PAY_ELEMENT_MAPPING PEM

877:
878: l_sql_from_where :=
879: ' FROM PA_PAY_AUDIT PAA,
880: PA_PAY_INTERFACE_TEMP PIT,
881: PA_PAY_ELEMENT_MAPPING PEM
882: WHERE PAA.INTERFACE_RUN_ID = :C_INTERFACE_RUN_ID
883: AND PAA.BATCH_ID = PIT.PAYROLL_ACTION_ID
884: AND PAA.PAYROLL_ID = PIT.PAYROLL_ID
885: AND PAA.TIME_PERIOD_ID = PIT.TIME_PERIOD_ID

Line 942: Payroll data will be grouped as per the Pay Element Rule set-ups in PA_PAY_ELEMENT_MAPPING

938: Procedure : LOAD_SOURCE_AMOUNTS_EXT
939: Type : Private
940: Purpose :
941: Below procedure loads the Third Party payroll data to PA_PAY_SOURCE_AMOUNTS.
942: Payroll data will be grouped as per the Pay Element Rule set-ups in PA_PAY_ELEMENT_MAPPING
943: and the org/project/task segment values
944: Note : Applicable only for External Payroll.
945:
946: */

Line 1015: PA_PAY_ELEMENT_MAPPING PEM

1011: SUM(PAY_AMOUNT) PAY_AMOUNT
1012: FROM
1013: PA_PAY_AUDIT PAA ,
1014: PA_PAY_EXT_INTERAFACE_V PPEI,
1015: PA_PAY_ELEMENT_MAPPING PEM
1016: WHERE
1017: PAA.REQUEST_ID = G_REQUEST_ID AND
1018: PAA.BATCH_ID = PPEI.PAYROLL_BATCH_ID AND
1019: PAA.PAYROLL_ID = PPEI.PAYROLL_ID AND