APPS.PAY_GB_RETRO_OVERLAP dependencies on PAY_UPGRADE_STATUS

Line 38: FROM pay_upgrade_status

34: CURSOR c_upgrade_status( cp_upgrade_defINation_id IN varchar2
35: ,cp_legISlation_code IN Varchar2)
36: IS
37: SELECT status
38: FROM pay_upgrade_status
39: WHERE legislation_code = cp_legislation_code
40: AND upgrade_definition_id = cp_upgrade_defination_id;
41: --
42:

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

129: END IF;
130:
131: CLOSE c_retro_rule_check;
132: ElSE
133: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
134: END IF;
135: CLOSE c_upgrade_status;
136: ELSE
137: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');