APPS.PA_PAY_INTERFACE dependencies on PA_PAY_EXT_INTERAFACE_V

Line 232: PA_PAY_EXT_INTERAFACE_V PPEI,

228: PPEI.RETRO_PERIOD_START_DATE ,
229: PPEI.RETRO_PERIOD_END_DATE,
230: PPEP.PRIORITY
231: FROM
232: PA_PAY_EXT_INTERAFACE_V PPEI,
233: PA_PAY_EXTERNAL_PAYROLL PPEP
234: WHERE PPEP.PAYROLL_ID = PPEI.PAYROLL_ID AND
235: Trunc(PPEI.TIME_PERIOD_END_DATE) BETWEEN P_DATE_START AND P_DATE_END
236: AND PPEI.PAYROLL_ID = Nvl(P_PAYROLL_ID,PPEI.PAYROLL_ID)

Line 1014: PA_PAY_EXT_INTERAFACE_V PPEI,

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
1018: PAA.BATCH_ID = PPEI.PAYROLL_BATCH_ID AND

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 5924: PA_PAY_EXT_INTERAFACE_V EXT ,

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
5928: AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID AND

Line 5950: PA_PAY_EXT_INTERAFACE_V EXT,

5946: (
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