APPS.PAY_US_RETRO_OVERLAP dependencies on PAY_UPGRADE_STATUS

Line 69: FROM pay_upgrade_status

65: CURSOR c_upgrade_status( cp_upgrade_defINation_id IN varchar2
66: ,cp_legISlation_code IN Varchar2)
67: IS
68: SELECT status
69: FROM pay_upgrade_status
70: WHERE legislation_code = cp_legislation_code
71: AND upgrade_definition_id = cp_upgrade_defination_id;
72: --
73:

Line 237: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');

233: legislation rule can be inserted */
234:
235: IF(c_upgrade_status%FOUND) THEN
236: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced RetroPay has Errored' );
237: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
238: l_enro_flag := 'N';
239: END IF;
240: --
241: IF(c_upgrade_status%NOTFOUND) THEN

Line 249: fnd_file.put_line(fnd_file.log,'There is no entries found in pay_upgrade_status table for Enhanced RetroPay');

245: l_enro_flag := 'Y';
246: ELSE
247: fnd_file.put_line(fnd_file.log,'Retro Pay by Element payroll process has been run.' );
248: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced Retropay is not run ');
249: fnd_file.put_line(fnd_file.log,'There is no entries found in pay_upgrade_status table for Enhanced RetroPay');
250: l_enro_flag := 'N';
251: END IF;
252: CLOSE c_check_retro_pay_element; */
253: /* Retro Enhanced and Retro Pay by element share same action type 'L'