APPS.PAY_US_RSRW_UPGREV dependencies on PAY_UPGRADE_DEFINITIONS

Line 2347: from pay_upgrade_definitions pud

2343:
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

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 2460: insert into pay_upgrade_definitions(UPGRADE_DEFINITION_ID

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
2461: ,SHORT_NAME
2462: ,NAME
2463: ,LEGISLATION_CODE
2464: ,DESCRIPTION

Line 2478: select PAY_UPGRADE_DEFINITIONS_S.nextval

2474: ,LAST_UPDATE_LOGIN
2475: ,CREATED_BY
2476: ,CREATION_DATE
2477: ,ADDITIONAL_INFO)
2478: select PAY_UPGRADE_DEFINITIONS_S.nextval
2479: ,'US_REG_EARNINGS_UPGRADE'
2480: ,'Upgrade Regular Earnings Elements for all US Business Groups'
2481: ,'US'
2482: ,'Upgrade Regular Earnings Elements for all US Business Groups'

Line 2502: select PAY_UPGRADE_DEFINITIONS_S.currval

2498:
2499: insert into pay_upgrade_status(UPGRADE_DEFINITION_ID
2500: ,STATUS
2501: ,LEGISLATION_CODE)
2502: select PAY_UPGRADE_DEFINITIONS_S.currval
2503: ,'C'
2504: ,'US' from sys.dual;
2505:
2506: EXCEPTION

Line 2599: from pay_upgrade_definitions pud

2595: -- Get Upgrade Status
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

Line 2690: delete from pay_upgrade_definitions

2686: where upgrade_definition_id = ln_upg_defn_id;
2687:
2688: ln_dbg_step := 3;
2689:
2690: delete from pay_upgrade_definitions
2691: where upgrade_definition_id = ln_upg_defn_id
2692: and short_name like 'US_REG_EARNINGS_UPGRADE'
2693: and legislation_code = 'US';
2694:

Line 2726: pay_upgrade_definitions tables for Upgrade of seeded

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.
2730: *****************************************************************************/

Line 2739: from pay_upgrade_definitions pud

2735: -- Get Upgrade Status
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