DBA Data[Home] [Help]

APPS.PAY_GB_MULTI_PAYROLL_RUN dependencies on PAY_PAYROLL_ACTIONS

Line 957: FROM PAY_PAYROLL_ACTIONS PPA WHERE PPA.REQUEST_ID=PROCESS_NAME;

953:
954: CURSOR CSR_PAYACT_ID(PROCESS_NAME IN NUMBER)
955: IS
956: SELECT PPA.PAYROLL_ACTION_ID
957: FROM PAY_PAYROLL_ACTIONS PPA WHERE PPA.REQUEST_ID=PROCESS_NAME;
958:
959:
960: T_ROLLBACK_REQ CHILD_REQ;
961: REQ_COUNT NUMBER;

Line 1080: FROM PAY_PAYROLL_ACTIONS PPA WHERE PPA.REQUEST_ID=PROCESS_NAME;

1076:
1077: CURSOR CSR_PAYACT_ID(PROCESS_NAME IN NUMBER)
1078: IS
1079: SELECT PPA.PAYROLL_ACTION_ID
1080: FROM PAY_PAYROLL_ACTIONS PPA WHERE PPA.REQUEST_ID=PROCESS_NAME;
1081:
1082:
1083: BEGIN
1084: V_AL_COUNT:=0;