APPS.PAY_GB_MULTI_PAYROLL_RUN dependencies on PAY_ALL_PAYROLLS_F

Line 203: PAY_ALL_PAYROLLS_F PAPF,

199:
200: CURSOR CSR_DEF_PAY_METHOD (P_PAYROLL_ID IN NUMBER) IS
201: SELECT DISTINCT POPMF.ORG_PAYMENT_METHOD_NAME
202: FROM
203: PAY_ALL_PAYROLLS_F PAPF,
204: PAY_ORG_PAYMENT_METHODS_F POPMF
205: WHERE PAPF.DEFAULT_PAYMENT_METHOD_ID=POPMF.ORG_PAYMENT_METHOD_ID
206: AND PAPF.BUSINESS_GROUP_ID=POPMF.BUSINESS_GROUP_ID
207: AND PAPF.PAYROLL_ID=P_PAYROLL_ID;

Line 214: FROM PAY_ALL_PAYROLLS_F

210:
211: CURSOR CSR_GET_CONS_ID(P_PAYROLL_ID IN NUMBER)
212: IS
213: SELECT CONSOLIDATION_SET_ID
214: FROM PAY_ALL_PAYROLLS_F
215: WHERE PAYROLL_ID=P_PAYROLL_ID;
216:
217: T_CHILD_REQ CHILD_REQ;
218: REQ_COUNT NUMBER;

Line 334: FROM PAY_ALL_PAYROLLS_F

330:
331: CURSOR CSR_GET_CONS_ID(P_PAYROLL_ID IN NUMBER)
332: IS
333: SELECT CONSOLIDATION_SET_ID
334: FROM PAY_ALL_PAYROLLS_F
335: WHERE PAYROLL_ID=P_PAYROLL_ID;
336:
337: BEGIN
338:

Line 475: FROM PAY_ALL_PAYROLLS_F

471:
472: CURSOR CSR_GET_CONS_ID(P_PAYROLL_ID IN NUMBER)
473: IS
474: SELECT CONSOLIDATION_SET_ID
475: FROM PAY_ALL_PAYROLLS_F
476: WHERE PAYROLL_ID=P_PAYROLL_ID;
477:
478: BEGIN
479: REQ_COUNT:=0;

Line 592: PAY_ALL_PAYROLLS_F PAPF,

588: CURSOR CSR_CONS_DET (P_PAYROLL_ID IN NUMBER)
589: IS
590:
591: SELECT PCS.CONSOLIDATION_SET_ID FROM
592: PAY_ALL_PAYROLLS_F PAPF,
593: PAY_CONSOLIDATION_SETS PCS
594: WHERE PAPF.CONSOLIDATION_SET_ID=PCS.CONSOLIDATION_SET_ID
595: AND PAPF.PAYROLL_ID=P_PAYROLL_ID;
596:

Line 776: FROM PAY_ALL_PAYROLLS_F

772:
773: CURSOR CSR_GET_CONS_ID(P_PAYROLL_ID IN NUMBER)
774: IS
775: SELECT CONSOLIDATION_SET_ID
776: FROM PAY_ALL_PAYROLLS_F
777: WHERE PAYROLL_ID=P_PAYROLL_ID;
778:
779:
780: