APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_PATCH_STATUS_S

Line 139: l_status pay_patch_status.status%TYPE;

135: l_date DATE;
136: l_generate_id pay_patch_status.id%TYPE;
137: l_generate_applied_date DATE;
138: l_patch_name pay_patch_status.patch_name%TYPE;
139: l_status pay_patch_status.status%TYPE;
140:
141: BEGIN
142:
143: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');

Line 231: SELECT pay_patch_status_s.NEXTVAL,

227: hr_utility.raise_error;
228:
229: END;
230:
231: SELECT pay_patch_status_s.NEXTVAL,
232: 'PSDUPGRADE_'||to_char(sysdate,'DDMONYYYYHHMISS'),
233: TRUNC(sysdate),
234: 'P'
235: INTO l_id,l_patch_name,l_date,l_status

Line 328: SELECT pay_patch_status_s.NEXTVAL,

324: AND legislation_code = 'US'
325: AND id > l_prev_upgrade_id
326: AND description = 'GENERATE';
327:
328: SELECT pay_patch_status_s.NEXTVAL,
329: 'PSDUPGRADE_'||to_char(sysdate,'DDMONYYYYHHMISS'),
330: TRUNC(sysdate),
331: 'P'
332: INTO l_id,l_patch_name,l_date,l_status