APPS.PAY_US_RETRO_OVERLAP dependencies on PAY_UPGRADE_STATUS

Line 50: FROM pay_upgrade_status

46: CURSOR c_upgrade_status( cp_upgrade_defINation_id IN varchar2
47: ,cp_legISlation_code IN Varchar2)
48: IS
49: SELECT status
50: FROM pay_upgrade_status
51: WHERE legislation_code = cp_legislation_code
52: AND upgrade_definition_id = cp_upgrade_defination_id;
53: --
54:

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

142:
143: CLOSE c_retro_rule_check;
144: ElSE
145: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced RetroPay has Errored' );
146: fnd_file.put_line(fnd_file.log,'The status of Enhanced RetroPay must be C in pay_upgrade_status table');
147: END IF;
148: CLOSE c_upgrade_status;
149: ELSE
150: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced Retropay has not completed ');