DBA Data[Home] [Help]

APPS.PAY_GB_MULTI_PAYROLL_RUN dependencies on PAY_ALL_PAYROLLS_F

Line 19: PAY_ALL_PAYROLLS_F PAPF,

15: SELECT PAPF.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID,
16: PTP.REGULAR_PAYMENT_DATE REGULAR_PAY_DATE,
17: PTP.END_DATE END_DATE
18: FROM
19: PAY_ALL_PAYROLLS_F PAPF,
20: PER_TIME_PERIODS PTP
21: WHERE PTP.PAYROLL_ID=PAPF.PAYROLL_ID
22: AND PAPF.PAYROLL_ID=P_PAYROLL_ID
23: AND PTP.PERIOD_NAME=P_TIME_PERIOD_NAME;

Line 32: PAY_ALL_PAYROLLS_F PAPF,

28: */
29: CURSOR CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID IN NUMBER) IS
30: SELECT PAPF.PAYROLL_ID
31: FROM
32: PAY_ALL_PAYROLLS_F PAPF,
33: PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM,
34: PAY_GB_PAYROLL_GROUPS PGPG
35: WHERE PGPGM.PAYROLL_ID=PAPF.PAYROLL_ID
36: AND PGPGM.PAYROLL_GROUP_ID=PGPG.PAYROLL_GROUP_ID