APPS.PAY_GB_RETRO_OVERLAP dependencies on PAY_UPGRADE_DEFINITIONS

Line 29: FROM pay_upgrade_definitions

25: CURSOR c_upgrade_definitions( cp_short_name IN varchar2
26: ,cp_legislation_code IN Varchar2)
27: IS
28: SELECT upgrade_definition_id
29: FROM pay_upgrade_definitions
30: WHERE legislation_code = cp_legislation_code
31: AND short_name=cp_short_name;
32:
33: -- Cursor to fetch the status of Enhanced Retropay

Line 96: -- Checking whether Enhanced Retropay entire is found in the table pay_upgrade_definitions or not

92: lv_short_name := 'GB_ENHANCED_RETROPAY';
93: OPEN c_upgrade_definitions(lv_short_name,lv_legislation_code);
94: FETCH c_upgrade_definitions into lv_upgrade_defination_id;
95:
96: -- Checking whether Enhanced Retropay entire is found in the table pay_upgrade_definitions or not
97: IF(c_upgrade_definitions%FOUND)
98: THEN
99: lv_upgrade_status := 'C';
100: OPEN c_upgrade_status(lv_upgrade_defination_id,lv_legislation_code);

Line 137: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');

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');
138: END IF;
139: CLOSE c_upgrade_definitions;
140: END IF;
141: