APPS.PAY_US_RSRW_UPGREV dependencies on PAY_UPGRADE_STATUS

Line 2348: ,pay_upgrade_status pus

2344: -- Get Upgrade Status
2345: CURSOR get_upg_status is
2346: select pus.status
2347: from pay_upgrade_definitions pud
2348: ,pay_upgrade_status pus
2349: where pud.short_name = 'US_REG_EARNINGS_UPGRADE'
2350: and pud.legislation_code = 'US'
2351: and pud.upgrade_definition_id = pus.upgrade_definition_id
2352: and pus.legislation_code = 'US';

Line 2456: /* Insert records into pay_upgrade_definitions and pay_upgrade_status */

2452: AND legislation_code = 'US'
2453: AND element_information_category = 'US_EARNINGS'
2454: AND element_information1 = 'REG';
2455:
2456: /* Insert records into pay_upgrade_definitions and pay_upgrade_status */
2457:
2458: ln_dbg_step := 2;
2459:
2460: insert into pay_upgrade_definitions(UPGRADE_DEFINITION_ID

Line 2499: insert into pay_upgrade_status(UPGRADE_DEFINITION_ID

2495: ,'Run through separate conc program' from sys.dual;
2496:
2497: ln_dbg_step := 3;
2498:
2499: insert into pay_upgrade_status(UPGRADE_DEFINITION_ID
2500: ,STATUS
2501: ,LEGISLATION_CODE)
2502: select PAY_UPGRADE_DEFINITIONS_S.currval
2503: ,'C'

Line 2600: ,pay_upgrade_status pus

2596: CURSOR get_upg_status is
2597: select pus.status
2598: ,pud.upgrade_definition_id
2599: from pay_upgrade_definitions pud
2600: ,pay_upgrade_status pus
2601: where pud.short_name = 'US_REG_EARNINGS_UPGRADE'
2602: and pud.legislation_code = 'US'
2603: and pud.upgrade_definition_id = pus.upgrade_definition_id
2604: and pus.legislation_code = 'US';

Line 2685: delete from pay_upgrade_status

2681: AND element_information1 = 'REG';
2682:
2683: ln_dbg_step := 2;
2684:
2685: delete from pay_upgrade_status
2686: where upgrade_definition_id = ln_upg_defn_id;
2687:
2688: ln_dbg_step := 3;
2689:

Line 2725: Description : This Function checks record from pay_upgrade_status and

2721:
2722: /*****************************************************************************
2723: Name : get_upgrade_flag
2724:
2725: Description : This Function checks record from pay_upgrade_status and
2726: pay_upgrade_definitions tables for Upgrade of seeded
2727: Regular Earnings elements "Regular Salary" and "Regular
2728: Wages" and return 'Y' or 'N' to be used by respective
2729: Fast Formula to determine what logic is to be used.

Line 2740: ,pay_upgrade_status pus

2736: CURSOR get_upg_status is
2737: select pus.status
2738: ,pud.upgrade_definition_id
2739: from pay_upgrade_definitions pud
2740: ,pay_upgrade_status pus
2741: where pud.short_name = 'US_REG_EARNINGS_UPGRADE'
2742: and pud.legislation_code = 'US'
2743: and pud.upgrade_definition_id = pus.upgrade_definition_id
2744: and pus.legislation_code = 'US';