APPS.PAY_NL_GENERAL dependencies on PAY_PATCH_STATUS

Line 2729: FROM pay_patch_status

2725:
2726: CURSOR csr_check
2727: IS
2728: SELECT *
2729: FROM pay_patch_status
2730: WHERE patch_number = 9453856
2731: AND patch_name = 'NL_9453856'
2732: AND phase = 'C'
2733: AND legislation_code = 'NL';

Line 2939: INSERT INTO pay_patch_status

2935:
2936: END LOOP;
2937: END IF;
2938:
2939: INSERT INTO pay_patch_status
2940: (id,patch_number,patch_name,phase,applied_date,legislation_code)
2941: SELECT pay_patch_status_s.nextval,9453856,'NL_9453856','C',sysdate,'NL' FROM dual;
2942:
2943: END IF;

Line 2941: SELECT pay_patch_status_s.nextval,9453856,'NL_9453856','C',sysdate,'NL' FROM dual;

2937: END IF;
2938:
2939: INSERT INTO pay_patch_status
2940: (id,patch_number,patch_name,phase,applied_date,legislation_code)
2941: SELECT pay_patch_status_s.nextval,9453856,'NL_9453856','C',sysdate,'NL' FROM dual;
2942:
2943: END IF;
2944:
2945: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',320);