APPS.PAY_CA_RETRO_OVERLAP dependencies on PAY_UPGRADE_DEFINITIONS

Line 41: FROM pay_upgrade_definitions

37: CURSOR c_upgrade_definitions( cp_short_name IN varchar2
38: ,cp_legislation_code IN Varchar2)
39: IS
40: SELECT upgrade_definition_id
41: FROM pay_upgrade_definitions
42: WHERE legislation_code = cp_legislation_code
43: AND short_name=cp_short_name;
44:
45: -- Cursor to fetch the status of Enhanced Retropay

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

104: lv_short_name := 'CA_ENHANCED_RETROPAY';
105: OPEN c_upgrade_definitions(lv_short_name,lv_legislation_code);
106: FETCH c_upgrade_definitions into lv_upgrade_defination_id;
107:
108: -- Checking whether Enhanced Retropay entire is found in the table pay_upgrade_definitions or not
109: IF(c_upgrade_definitions%FOUND)
110: THEN
111: lv_upgrade_status := 'C';
112: OPEN c_upgrade_status(lv_upgrade_defination_id,lv_legislation_code);

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

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 ');
151: fnd_file.put_line(fnd_file.log,'There is no entrie found in pay_upgrade_definitions table for Enhanced RetroPay');
152: END IF;
153: CLOSE c_upgrade_definitions;
154: END IF;
155: