eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PAY_INTERFACE dependencies on PA_PAY_AUDIT

Line 120: Makes an entry in PA_PAY_AUDIT table.

116: Type : Private
117: Purpose :
118: Generates the interface_run_id which is the unique identifier for
119: each payroll batch .
120: Makes an entry in PA_PAY_AUDIT table.
121:
122: */
123:
124: PROCEDURE INSERT_AUDIT_RECORDS

Line 162: PA_PAY_AUDIT_ALL

158: INTO
159: L_RUN_SEQUENCE ,
160: L_MAX_RUN_ID
161: FROM
162: PA_PAY_AUDIT_ALL
163: WHERE
164: BATCH_ID = X.PAYROLL_ACTION_ID AND
165: PAYROLL_ID = X.PAYROLL_ID AND
166: TIME_PERIOD_ID = X.TIME_PERIOD_ID ;

Line 176: PA_PAY_AUDIT

172: END;
173:
174: INSERT
175: INTO
176: PA_PAY_AUDIT
177: (
178: ORG_ID ,
179: BATCH_ID ,
180: PAYROLL_ID ,

Line 254: PA_PAY_AUDIT_ALL

250: INTO
251: L_RUN_SEQUENCE ,
252: L_MAX_RUN_ID
253: FROM
254: PA_PAY_AUDIT_ALL
255: WHERE
256: BATCH_ID = X.PAYROLL_BATCH_ID AND
257: PAYROLL_ID = X.PAYROLL_ID AND
258: TIME_PERIOD_ID = X.TIME_PERIOD_ID ;

Line 268: PA_PAY_AUDIT

264: END;
265: write_log (LOG, 'Checking for third Party payrolls' );
266: INSERT
267: INTO
268: PA_PAY_AUDIT
269: (
270: ORG_ID ,
271: BATCH_ID ,
272: PAYROLL_ID ,

Line 358: FROM PA_PAY_AUDIT PAA,

354: PIT.ELEMENT_TYPE_ID,
355: PEM.PAYROLL_PROJ_SEGMENT,
356: PEM.PAYROLL_TASK_SEGMENT,
357: PEM.PAYROLL_EXP_ORG_SEGMENT
358: FROM PA_PAY_AUDIT PAA,
359: (select distinct
360: PAYROLL_ACTION_ID ,
361: PAYROLL_ID,
362: TIME_PERIOD_ID,

Line 447: FOR X IN (SELECT * FROM PA_PAY_AUDIT WHERE request_id = G_REQUEST_ID ORDER BY INTERFACE_RUN_ID)

443: /*
444: Interface Run Ids (Batches ) have to processed one by one in order.
445: This logic should not change with out PM Approval
446: */
447: FOR X IN (SELECT * FROM PA_PAY_AUDIT WHERE request_id = G_REQUEST_ID ORDER BY INTERFACE_RUN_ID)
448: LOOP
449: write_log( Log, '=========== Processing starts for =========== ' ) ;
450: write_log( Log, 'Payroll Id -' || X.PAYROLL_ID ) ;
451: write_log( Log, 'Pay Period Start -' || X.PAY_PERIOD_START_DATE );

Line 879: ' FROM PA_PAY_AUDIT PAA,

875: l_insert_random := l_insert_random || ' , PAY_AMOUNT )';
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

Line 1013: PA_PAY_AUDIT PAA ,

1009: TRUNC(sysdate) C_UPDATE_DATE ,
1010: fnd_global.user_id C_UPDATE_BY,
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

Line 1180: PA_PAY_SOURCE_AMOUNTS PPS, PA_PAY_AUDIT PPA

1176: G_USER_ID ,
1177: G_RUN_DATE ,
1178: G_USER_ID
1179: FROM
1180: PA_PAY_SOURCE_AMOUNTS PPS, PA_PAY_AUDIT PPA
1181: WHERE
1182: PPS.INTERFACE_RUN_ID = PPA.INTERFACE_RUN_ID AND
1183: PPA.SOURCE_START_DATE IS NULL AND
1184: PPS.PAY_AMOUNT < 0 AND

Line 1253: PA_PAY_AUDIT

1249: INTERFACE_RUN_ID ,
1250: TRUNC(Nvl(SOURCE_START_DATE,PAY_PERIOD_START_DATE))START_DATE ,
1251: TRUNC(Nvl(SOURCE_END_DATE,PAY_PERIOD_END_DATE)) END_DATE
1252: FROM
1253: PA_PAY_AUDIT
1254: WHERE
1255: REQUEST_ID = G_REQUEST_ID
1256: )
1257: LOOP

Line 1567: PA_PAY_AUDIT PPA

1563: G_RUN_DATE ,
1564: G_USER_ID
1565: FROM
1566: PA_PAY_SOURCE_AMOUNTS PPSA,
1567: PA_PAY_AUDIT PPA
1568: WHERE
1569: PPSA.INTERFACE_RUN_ID = PPA.INTERFACE_RUN_ID AND
1570: PAY_SOURCE_ORGANIZATION_ID IS NOT NULL AND
1571: PPSA.DISTRIBUTION_BASIS_CODE in ('ST_AMT',

Line 1952: PA_PAY_AUDIT AUD

1948: WHERE EXPENDITURE_ITEM_ID =
1949: (SELECT MAX(EI5.EXPENDITURE_ITEM_ID)
1950: FROM PA_EXPENDITURE_ITEMS EI4 ,
1951: PA_EXPENDITURE_ITEMS EI5 ,
1952: PA_PAY_AUDIT AUD
1953: WHERE EI4.EXPENDITURE_ITEM_ID = T.EXPENDITURE_ITEM_ID
1954: AND EI4.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
1955: AND EI5.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
1956: AND EI5.INTERFACE_RUN_ID IS NOT NULL

Line 1958: AND AUD.BATCH_ID <> (SELECT BATCH_ID FROM PA_PAY_AUDIT WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID)

1954: AND EI4.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
1955: AND EI5.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
1956: AND EI5.INTERFACE_RUN_ID IS NOT NULL
1957: AND EI5.INTERFACE_RUN_ID = AUD.INTERFACE_RUN_ID
1958: AND AUD.BATCH_ID <> (SELECT BATCH_ID FROM PA_PAY_AUDIT WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID)
1959: AND SUBSTR(EI5.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI5.ORIG_TRANSACTION_REFERENCE,':') - 1) = SUBSTR(EI4.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI4.ORIG_TRANSACTION_REFERENCE,':') - 1)
1960: AND EI5.COST_DISTRIBUTED_FLAG = 'Y'
1961: AND EI5.ADJUSTED_EXPENDITURE_ITEM_ID IS NULL
1962: )

Line 1973: ,PA_PAY_AUDIT AUD2

1969: AND EI1.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
1970: AND EXISTS
1971: (SELECT 1
1972: FROM PA_EXPENDITURE_ITEMS EI2
1973: ,PA_PAY_AUDIT AUD2
1974: WHERE EI2.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
1975: AND EI2.INTERFACE_RUN_ID IS NOT NULL
1976: AND EI2.INTERFACE_RUN_ID = AUD2.INTERFACE_RUN_ID
1977: AND AUD2.BATCH_ID <> (SELECT BATCH_ID FROM PA_PAY_AUDIT WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID)

Line 1977: AND AUD2.BATCH_ID <> (SELECT BATCH_ID FROM PA_PAY_AUDIT WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID)

1973: ,PA_PAY_AUDIT AUD2
1974: WHERE EI2.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
1975: AND EI2.INTERFACE_RUN_ID IS NOT NULL
1976: AND EI2.INTERFACE_RUN_ID = AUD2.INTERFACE_RUN_ID
1977: AND AUD2.BATCH_ID <> (SELECT BATCH_ID FROM PA_PAY_AUDIT WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID)
1978: AND SUBSTR(EI2.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1) = SUBSTR(EI1.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI1.ORIG_TRANSACTION_REFERENCE,':') - 1)
1979: AND COST_DISTRIBUTED_FLAG = 'Y'
1980: AND ADJUSTED_EXPENDITURE_ITEM_ID IS NULL )
1981: ) ;

Line 3756: l_int_ext_flag pa_pay_audit.INT_EXT_INDICATOR%TYPE;

3752:
3753: */
3754:
3755: PROCEDURE reject_pe_no_setup IS
3756: l_int_ext_flag pa_pay_audit.INT_EXT_INDICATOR%TYPE;
3757:
3758: BEGIN
3759:
3760:

Line 3764: FROM pa_pay_audit_all

3760:
3761: SELECT INT_EXT_INDICATOR
3762: INTO
3763: l_int_ext_flag
3764: FROM pa_pay_audit_all
3765: WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID ;
3766:
3767: IF l_int_ext_flag = 'INT' THEN
3768:

Line 3797: PA_PAY_INTERFACE_TEMP TEMP, PA_PAY_AUDIT AUD

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))

Line 3858: PA_PAY_EXT_INTERAFACE_V EXT, PA_PAY_AUDIT AUD

3854: G_USER_ID LAST_UPDATED_BY ,
3855: G_RUN_DATE CREATION_DATE ,
3856: G_USER_ID CREATED_BY
3857: FROM
3858: PA_PAY_EXT_INTERAFACE_V EXT, PA_PAY_AUDIT AUD
3859: WHERE
3860: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
3861: EXT.TIME_PERIOD_ID = AUD.TIME_PERIOD_ID AND
3862: EXT.PERSON_ID = G_PERSON_ID AND

Line 5575: PA_PAY_AUDIT AUD

5571: WHERE EI2.EXPENDITURE_ITEM_ID IN
5572: ( SELECT EI.EXPENDITURE_ITEM_ID
5573: FROM PA_EXPENDITURE_ITEMS_ALL EI ,
5574: PA_EXPENDITURES_ALL E,
5575: PA_PAY_AUDIT AUD
5576: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5577: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5578: AND EI.EXPENDITURE_ID = E.EXPENDITURE_ID
5579: AND Trunc(EXPENDITURE_ITEM_DATE) BETWEEN Trunc(Nvl(AUD.SOURCE_START_DATE,AUD.PAY_PERIOD_START_DATE)) AND Trunc( Nvl(AUD.SOURCE_END_DATE,AUD.PAY_PERIOD_END_DATE))

Line 5599: PA_PAY_AUDIT AUD

5595: NVL((-1*EI.DENOM_RAW_COST),0),
5596: G_INTERFACE_RUN_ID,'ACTUAL',NVL(EI.PAYROLL_ACCRUAL_FLAG,'N'),G_REQUEST_ID FROM
5597: PA_EXPENDITURE_ITEMS Ei,
5598: PA_EXPENDITURES E,
5599: PA_PAY_AUDIT AUD
5600: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5601: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5602: AND EI2.EXPENDITURE_ID = E.EXPENDITURE_ID
5603: AND EI2.EXPENDITURE_ITEM_DATE BETWEEN Trunc(Nvl(AUD.SOURCE_START_DATE,AUD.PAY_PERIOD_START_DATE))

Line 5629: PA_PAY_AUDIT AUD

5625:
5626: FOR X IN (SELECT EI2.EXPENDITURE_ITEM_ID,EI2.TRANSACTION_SOURCE,EI2.ADJUSTED_EXPENDITURE_ITEM_ID
5627: FROM PA_EXPENDITURE_ITEMS EI2 ,
5628: PA_EXPENDITURES E,
5629: PA_PAY_AUDIT AUD
5630: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5631: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5632: AND EI2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5633: AND EI2.EXPENDITURE_ID = E.EXPENDITURE_ID

Line 5663: PA_PAY_AUDIT AUD

5659: WHERE EI2.EXPENDITURE_ITEM_ID IN
5660: (SELECT EXPENDITURE_ITEM_ID
5661: FROM PA_EXPENDITURE_ITEMS Ei3
5662: ,PA_EXPENDITURES E,
5663: PA_PAY_AUDIT AUD
5664: WHERE EI3.EXPENDITURE_ITEM_ID IN
5665: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID
5666: CONNECT BY PRIOR TRANSFERRED_FROM_EXP_ITEM_ID=EXPENDITURE_ITEM_ID
5667: UNION

Line 5845: l_int_ext_flag pa_pay_audit.INT_EXT_INDICATOR%TYPE;

5841:
5842: PROCEDURE mark_processed
5843: IS
5844: l_status VARCHAR2(30);
5845: l_int_ext_flag pa_pay_audit.INT_EXT_INDICATOR%TYPE;
5846: BEGIN
5847:
5848:
5849: SELECT INT_EXT_INDICATOR

Line 5852: FROM pa_pay_audit_all

5848:
5849: SELECT INT_EXT_INDICATOR
5850: INTO
5851: l_int_ext_flag
5852: FROM pa_pay_audit_all
5853: WHERE INTERFACE_RUN_ID = G_INTERFACE_RUN_ID ;
5854:
5855: IF l_int_ext_flag = 'INT' THEN
5856:

Line 5866: PA_PAY_AUDIT AUD ,

5862: ASSIGNMENT_ACTION_ID ,
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

Line 5884: PA_PAY_AUDIT AUD ,

5880: ASSIGNMENT_ACTION_ID ,
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

Line 5923: PA_PAY_AUDIT AUD ,

5919:
5920: SELECT
5921: EXT.INTERFACE_LINE_ID
5922: FROM
5923: PA_PAY_AUDIT AUD ,
5924: PA_PAY_EXT_INTERAFACE_V EXT ,
5925: PA_PAY_SOURCE_AMOUNTS SRC
5926: WHERE
5927: AUD.INT_EXT_INDICATOR = 'EXT' AND

Line 5951: PA_PAY_AUDIT AUD

5947: SELECT
5948: EXT.INTERFACE_LINE_ID
5949: FROM
5950: PA_PAY_EXT_INTERAFACE_V EXT,
5951: PA_PAY_AUDIT AUD
5952: WHERE
5953: AUD.INT_EXT_INDICATOR = 'EXT' AND
5954: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND
5955: Trunc(EXT.TIME_PERIOD_START_DATE) = Trunc(AUD.PAY_PERIOD_START_DATE) AND

Line 6019: PA_PAY_AUDIT AUD

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
6023: TEMP.PERSON_ID = G_PERSON_ID AND