APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_PATCH_STATUS

Line 4597: FROM pay_patch_status

4593: b_script_already_run BOOLEAN;
4594: --
4595: CURSOR c_del_dtls IS
4596: SELECT *
4597: FROM pay_patch_status
4598: WHERE patch_number = 5758299
4599: AND patch_name = 'JP_UPGRADE_R12'
4600: AND phase = 'C'
4601: AND legislation_code = 'JP';

Line 4722: INSERT INTO pay_patch_status

4718: l_global_rec.creation_date);
4719: -- dbms_output.put_line('Global Value DBI: ' || l_global_rec.global_name || ' created.');
4720: end loop;
4721: --
4722: INSERT INTO pay_patch_status
4723: (id
4724: ,patch_number
4725: ,patch_name
4726: ,phase

Line 4729: SELECT pay_patch_status_s.nextval

4725: ,patch_name
4726: ,phase
4727: ,applied_date
4728: ,legislation_code)
4729: SELECT pay_patch_status_s.nextval
4730: ,5758299
4731: ,'JP_UPGRADE_R12'
4732: ,'C'
4733: ,sysdate