APPS.PAY_US_RETRO_OVERLAP dependencies on PAY_UPGRADE_DEFINITIONS

Line 60: FROM pay_upgrade_definitions

56: CURSOR c_upgrade_definitions( cp_short_name IN varchar2
57: ,cp_legislation_code IN Varchar2)
58: IS
59: SELECT upgrade_definition_id
60: FROM pay_upgrade_definitions
61: WHERE legislation_code = cp_legislation_code
62: AND short_name=cp_short_name;
63:
64: -- Cursor to fetch the status of Enhanced Retropay

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

179: lv_short_name := 'US_ENHANCED_RETROPAY';
180: OPEN c_upgrade_definitions(lv_short_name,lv_legislation_code);
181: FETCH c_upgrade_definitions into lv_upgrade_defination_id;
182:
183: -- Checking whether Enhanced Retropay entire is found in the table pay_upgrade_definitions or not
184: IF(c_upgrade_definitions%FOUND)
185: THEN
186: lv_upgrade_status := 'C';
187: OPEN c_upgrade_status(lv_upgrade_defination_id,lv_legislation_code);

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

290:
291: CLOSE c_upgrade_status;
292: ELSE
293: fnd_file.put_line(fnd_file.log,'Upgrade process of Enhanced Retropay has not completed ');
294: fnd_file.put_line(fnd_file.log,'There is no entries found in pay_upgrade_definitions table for Enhanced RetroPay');
295: l_enro_flag := 'N';
296: END IF;
297:
298: --