APPS.PAY_IE_MEDICAL_ADJUST dependencies on PAY_PATCH_STATUS

Line 253: FROM pay_patch_status

249:
250: -- Cursor to prevent this process running twice.
251: CURSOR c_already_run IS
252: SELECT 1
253: FROM pay_patch_status
254: WHERE patch_number = 6506755
255: AND patch_name = 'IE_MED_BAL_ADJ'
256: AND phase = 'C'
257: AND legislation_code = 'IE';

Line 450: INSERT INTO pay_patch_status(id

446: */
447: END;
448: END LOOP;
449: --
450: INSERT INTO pay_patch_status(id
451: ,patch_number
452: ,patch_name
453: ,phase
454: ,applied_date

Line 456: SELECT pay_patch_status_s.nextval

452: ,patch_name
453: ,phase
454: ,applied_date
455: ,legislation_code)
456: SELECT pay_patch_status_s.nextval
457: ,6506755
458: ,'IE_MED_BAL_ADJ'
459: ,'C'
460: ,sysdate