APPS.PAY_GB_MULTI_DML_AND_VAL dependencies on PAY_GB_PAYROLL_GROUP_MAPPINGS

Line 120: FROM PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM

116: V_STATUS:=0;
117: hr_utility.trace('V_STATUS:'||V_STATUS);
118: SELECT PGPGM.PAYROLL_ID INTO
119: V_PAYROLL_ID
120: FROM PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM
121: WHERE PGPGM.PAYROLL_ID=P_PAYROLL_ID
122: AND PGPGM.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID;
123:
124: V_STATUS:=1;

Line 288: INSERT INTO PAY_GB_PAYROLL_GROUP_MAPPINGS

284: P_PAYROLL_ID, V_PAYROLL_GROUP_NAME)=2 THEN
285: hr_utility.trace('VAL_PAYROLLS_IN_GROUP returns 1');
286: hr_utility.trace('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID);
287: IF VALIDATE_FREQUENCY(P_PAYROLL_ID,P_PAYROLL_GROUP_ID)=1 THEN
288: INSERT INTO PAY_GB_PAYROLL_GROUP_MAPPINGS
289: (
290: PAYROLL_ID
291: ,PAYROLL_NAME
292: ,PAYROLL_GROUP_ID

Line 467: DELETE PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM

463: BEGIN
464:
465:
466:
467: DELETE PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM
468: WHERE PGPGM.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID
469: AND PGPGM.BUSINESS_GROUP_ID=P_BUSINESS_GROUP_ID;
470:
471: DELETE PAY_GB_PAYROLL_GROUPS PGPG

Line 485: DELETE PAY_GB_PAYROLL_GROUP_MAPPINGS

481:
482: IS
483: BEGIN
484:
485: DELETE PAY_GB_PAYROLL_GROUP_MAPPINGS
486: WHERE PAYROLL_ID=P_PAYROLL_ID
487: AND PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID;
488:
489: COMMIT;