[Home] [Help]
143: PPIT.TIME_PERIOD_ID ,
144: PPIT.SOURCE_START_DATE, /* bug 12690224*/
145: PPIT.SOURCE_END_DATE
146: FROM
147: PA_PAY_INTERFACE_TEMP PPIT
148: ORDER BY
149: PAYROLL_ACTION_ID
150:
151: )
362: TIME_PERIOD_ID,
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
566: /*
567: Procedure : LOAD_PA_PROJ_TEMP
568: Type : Private
569: Purpose :
570: Below procedure loads the payroll data to a GTT PA_PAY_INTERFACE_TEMP.
571: The is done so as to avoid acessing the Payroll tables for each employee.
572: */
573:
574:
583: BEGIN
584:
585:
586: INSERT
587: INTO PA_PAY_INTERFACE_TEMP
588: (
589: COST_TYPE,
590: EFFECTIVE_DATE,
591: BUSINESS_GROUP_ID,
876: l_sql_sel_random := l_sql_sel_random || ' SUM(PIT.DEBIT_AMOUNT- PIT.CREDIT_AMOUNT) AMOUNT';
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
3793: G_USER_ID LAST_UPDATED_BY ,
3794: G_RUN_DATE CREATION_DATE ,
3795: G_USER_ID CREATED_BY
3796: FROM
3797: PA_PAY_INTERFACE_TEMP TEMP, PA_PAY_AUDIT AUD
3798: WHERE
3799: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
3800: -- TEMP.TIME_PERIOD_ID = AUD.TIME_PERIOD_ID AND
3801: TRUNC(NVL(TEMP.SOURCE_START_DATE,TEMP.TIME_PERIOD_START_DATE)) = TRUNC(NVL(AUD.SOURCE_START_DATE,AUD.PAY_PERIOD_START_DATE))
5863: SRC.PAY_ELEMENT_TYPE_ID ,
5864: 'Y' STATUS
5865: FROM
5866: PA_PAY_AUDIT AUD ,
5867: PA_PAY_INTERFACE_TEMP TEMP ,
5868: PA_PAY_SOURCE_AMOUNTS SRC
5869: WHERE
5870: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
5871: AUD.INTERFACE_RUN_ID = SRC.INTERFACE_RUN_ID AND
5881: TEMP.ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID ,
5882: 'Z' STATUS
5883: FROM
5884: PA_PAY_AUDIT AUD ,
5885: PA_PAY_INTERFACE_TEMP TEMP
5886: WHERE
5887: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
5888: TRUNC(NVL(TEMP.SOURCE_START_DATE,TEMP.TIME_PERIOD_START_DATE)) = TRUNC(NVL(AUD.SOURCE_START_DATE,AUD.PAY_PERIOD_START_DATE)) AND
5889: TRUNC(NVL(TEMP.SOURCE_END_DATE,TEMP.TIME_PERIOD_END_DATE)) = TRUNC(NVL(AUD.SOURCE_END_DATE,AUD.PAY_PERIOD_END_DATE)) AND /* bug 12690224*/
6014: G_LOGIN_ID,
6015: G_REQUEST_ID ,
6016: ASSIGNMENT_ACTION_ID
6017: FROM
6018: PA_PAY_INTERFACE_TEMP TEMP ,
6019: PA_PAY_AUDIT AUD
6020: WHERE
6021: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
6022: TEMP.PAYROLL_ACTION_ID = AUD.BATCH_ID AND