eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPES_F

Line 157: from pay_element_types_f

153: ONCE_EACH_PERIOD_FLAG,
154: decode(TIME_DEFINITION_TYPE,'N',NULL,TIME_DEFINITION_TYPE) TIME_DEFINITION_TYPE, /* Bug 5749509*/
155: TIME_DEFINITION_ID,
156: OBJECT_VERSION_NUMBER
157: from pay_element_types_f
158: where element_type_id = p_element_type_id
159: and business_group_id = p_business_group_id
160: ORDER BY effective_start_date;
161:

Line 455: CURSOR c_get_formula_results(c_element_type_id pay_element_types_f.element_type_id%type)

451: WHERE ff.formula_name = 'AU_RETRO_ADDITIONAL_PROCESSED'
452: AND ff.legislation_code = 'AU';
453:
454: /* Gets the processing rule id for element */
455: CURSOR c_get_formula_results(c_element_type_id pay_element_types_f.element_type_id%type)
456: IS
457: SELECT pspr.status_processing_rule_id
458: FROM pay_status_processing_rules_f pspr
459: WHERE pspr.business_group_id = p_business_group_id

Line 463: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,

459: WHERE pspr.business_group_id = p_business_group_id
460: AND pspr.element_type_id = c_element_type_id;
461:
462: /* Checks whether formula result rule exist for the element */
463: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
464: c_result_name pay_formula_result_rules_f.result_name%type,
465: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
466: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
467: IS

Line 479: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)

475: AND DECODE(c_result_rule_type, 'M', '999', pfrr.input_value_id) = DECODE(c_result_rule_type, 'M', '999', c_input_value_id);
476:
477: /* Fetches the input value id for seeded Retropay elements */
478:
479: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
480: IS
481: SELECT DISTINCT pet.element_type_id, piv.input_value_id
482: FROM pay_input_values_f piv,
483: pay_element_types_f pet

Line 483: pay_element_types_f pet

479: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
480: IS
481: SELECT DISTINCT pet.element_type_id, piv.input_value_id
482: FROM pay_input_values_f piv,
483: pay_element_types_f pet
484: WHERE pet.element_name = c_element_name
485: AND pet.legislation_code = 'AU'
486: AND piv.element_type_id = pet.element_type_id
487: AND piv.NAME = c_name

Line 1155: from pay_element_types_f

1151: RECALC_EVENT_GROUP_ID,
1152: ONCE_EACH_PERIOD_FLAG,
1153: decode(TIME_DEFINITION_TYPE,'N',NULL,TIME_DEFINITION_TYPE) TIME_DEFINITION_TYPE,
1154: TIME_DEFINITION_ID
1155: from pay_element_types_f
1156: where element_type_id = p_retro_element_id
1157: and business_group_id = p_business_group_id
1158: ORDER BY effective_start_date desc;
1159:

Line 1176: FROM pay_element_types_f pet

1172: /* Checks whether retro element (LT12,GT12...) already exist before creating the element*/
1173: CURSOR c_element_exists
1174: IS
1175: SELECT pet.element_type_id
1176: FROM pay_element_types_f pet
1177: WHERE pet.element_name = rec_element_types.ELEMENT_NAME || ' ' || p_retro_type
1178: AND pet.business_group_id = p_business_group_id;
1179:
1180:

Line 1183: CURSOR c_get_element_links(c_element_type_id pay_element_types_f.element_type_id%type, p_effective_date date)

1179:
1180:
1181: /* Gets the details of the element link of retro element */
1182: /* 5731490 Fetches all the links associated with retro elements*/
1183: CURSOR c_get_element_links(c_element_type_id pay_element_types_f.element_type_id%type, p_effective_date date)
1184: IS
1185: SELECT pel.PAYROLL_ID,
1186: pel.JOB_ID,
1187: pel.POSITION_ID,

Line 1599: Procedure element_exist_check( p_element_type_id in pay_element_types_f.element_type_id%type

1595: -- or LT12 exist whether these elements were created by upgrade process.
1596: -- Procedure sets p_user_element_exist to 'Y' if GT12,LT12 elements were created by user
1597: -- and sets p_upgrade_element_exis to 'Y' if GT12,LT12 elements were created by upgrade process
1598:
1599: Procedure element_exist_check( p_element_type_id in pay_element_types_f.element_type_id%type
1600: ,p_business_group_id in number
1601: ,p_upgrade_element_exist out NOCOPY VARCHAR2
1602: ,p_user_element_exist out NOCOPY VARCHAR2)
1603: is

Line 1606: FROM pay_element_types_f pet1,

1602: ,p_user_element_exist out NOCOPY VARCHAR2)
1603: is
1604: CURSOR c_element_exists IS
1605: SELECT pet2.element_type_id,pet1.element_name,pet2.element_name
1606: FROM pay_element_types_f pet1,
1607: pay_element_types_f pet2
1608: WHERE pet2.element_name in (pet1.element_name || ' '||'GT12' ,
1609: pet1.element_name || ' '||'LT12 Prev',
1610: pet1.element_name || ' '||'LT12 Curr' )

Line 1607: pay_element_types_f pet2

1603: is
1604: CURSOR c_element_exists IS
1605: SELECT pet2.element_type_id,pet1.element_name,pet2.element_name
1606: FROM pay_element_types_f pet1,
1607: pay_element_types_f pet2
1608: WHERE pet2.element_name in (pet1.element_name || ' '||'GT12' ,
1609: pet1.element_name || ' '||'LT12 Prev',
1610: pet1.element_name || ' '||'LT12 Curr' )
1611: AND pet1.business_group_id = p_business_group_id

Line 1616: CURSOR upgraded_element_check(cp_element_type_id pay_element_types_f.element_type_id%type) IS

1612: and pet1.business_group_id= pet2.business_group_id
1613: and pet1.element_type_id=p_element_type_id;
1614:
1615:
1616: CURSOR upgraded_element_check(cp_element_type_id pay_element_types_f.element_type_id%type) IS
1617: select 'Y'
1618: from pay_element_type_extra_info
1619: where element_type_id= cp_element_type_id
1620: and information_type='AU_RETRO_UPGRADE_INFO' ;

Line 1622: l_element_type_id pay_element_types_f.element_type_id%type;

1618: from pay_element_type_extra_info
1619: where element_type_id= cp_element_type_id
1620: and information_type='AU_RETRO_UPGRADE_INFO' ;
1621:
1622: l_element_type_id pay_element_types_f.element_type_id%type;
1623: l_upg_element_name pay_element_types_f.element_name%type;
1624: l_retro_element_name pay_element_types_f.element_name%type;
1625: l_upgraded_element char(1);
1626: l_user_element_exist char(1);

Line 1623: l_upg_element_name pay_element_types_f.element_name%type;

1619: where element_type_id= cp_element_type_id
1620: and information_type='AU_RETRO_UPGRADE_INFO' ;
1621:
1622: l_element_type_id pay_element_types_f.element_type_id%type;
1623: l_upg_element_name pay_element_types_f.element_name%type;
1624: l_retro_element_name pay_element_types_f.element_name%type;
1625: l_upgraded_element char(1);
1626: l_user_element_exist char(1);
1627: l_upgrade_element_exist char(1);

Line 1624: l_retro_element_name pay_element_types_f.element_name%type;

1620: and information_type='AU_RETRO_UPGRADE_INFO' ;
1621:
1622: l_element_type_id pay_element_types_f.element_type_id%type;
1623: l_upg_element_name pay_element_types_f.element_name%type;
1624: l_retro_element_name pay_element_types_f.element_name%type;
1625: l_upgraded_element char(1);
1626: l_user_element_exist char(1);
1627: l_upgrade_element_exist char(1);
1628: lv_procedure_name varchar2(30);

Line 1708: from pay_element_types_f pet

1704: pec.classification_name,
1705: pet.retro_summ_ele_id, /* Bug 5731490 */
1706: decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) ||
1707: decode(instr(pec.classification_name, 'Deductions'), 0, null, pec.classification_name ) label
1708: from pay_element_types_f pet
1709: ,pay_element_classifications pec
1710: ,pay_element_classifications pec2
1711: ,pay_sub_classification_rules_f pscr
1712: where pet.element_type_id = cp_element_type_id

Line 1763: pay_element_types_f pet,

1759: and petr.include_or_exclude = 'I'
1760: union all
1761: select pes.element_set_id
1762: from pay_ele_classification_rules pecr,
1763: pay_element_types_f pet,
1764: pay_element_sets pes
1765: where pet.classification_id = pecr.classification_id
1766: and pes.element_set_id = pecr.element_set_id
1767: and (pes.business_group_id = pet.business_group_id

Line 1958: FROM pay_element_types_f pet,

1954: nvl(pet.retro_summ_ele_id, pet.element_type_id),
1955: pet.element_name, pec.classification_name
1956: ,pet.retro_summ_ele_id
1957: ,decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) label
1958: FROM pay_element_types_f pet,
1959: pay_element_classifications pec
1960: ,pay_element_classifications pec2
1961: ,pay_sub_classification_rules_f pscr
1962: WHERE pet.element_type_id = cp_element_type_id

Line 1986: pay_element_types_f pet,

1982: and petr.include_or_exclude = 'I'
1983: union all
1984: select pes.element_set_id
1985: from pay_ele_classification_rules pecr,
1986: pay_element_types_f pet,
1987: pay_element_sets pes
1988: where pet.classification_id = pecr.classification_id
1989: and pes.element_set_id = pecr.element_set_id
1990: and (pes.business_group_id = pet.business_group_id

Line 2050: from pay_element_types_f pet1,

2046:
2047: /* Gets the name of the attached retro element */
2048: cursor c_retro_element_name(cp_element_type_id in number) is /* 5461629 */
2049: select pet2.element_name
2050: from pay_element_types_f pet1,
2051: pay_element_types_f pet2
2052: where pet1.element_type_id = cp_element_type_id
2053: AND nvl(pet1.retro_summ_ele_id, pet1.element_type_id) = pet2.element_type_id;
2054:

Line 2051: pay_element_types_f pet2

2047: /* Gets the name of the attached retro element */
2048: cursor c_retro_element_name(cp_element_type_id in number) is /* 5461629 */
2049: select pet2.element_name
2050: from pay_element_types_f pet1,
2051: pay_element_types_f pet2
2052: where pet1.element_type_id = cp_element_type_id
2053: AND nvl(pet1.retro_summ_ele_id, pet1.element_type_id) = pet2.element_type_id;
2054:
2055:

Line 2089: ln_retro_summ_ele_id pay_element_types_f.retro_summ_ele_id%TYPE;

2085: l_user_element_exist char(1);
2086: l_upgrade_element_exist char(1);
2087:
2088: /* Bug 5731490 - Added variables */
2089: ln_retro_summ_ele_id pay_element_types_f.retro_summ_ele_id%TYPE;
2090: lv_class_label varchar2(100);
2091:
2092: l_migrator_mode_status VARCHAR2(2);
2093:

Line 2992: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE

2988: --------------------------------------------------------------------------
2989: PROCEDURE create_element_spans
2990: (p_retro_component_usage_id IN pay_retro_component_usages.retro_component_usage_id%TYPE
2991: ,p_retro_component_id IN pay_retro_components.retro_component_id%TYPE
2992: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE
2993: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2994: )
2995: IS
2996: --

Line 2998: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2994: )
2995: IS
2996: --
2997: l_time_span_id pay_time_spans.time_span_id%TYPE;
2998: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2999: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
3000: --
3001: CURSOR csr_get_element_type_id IS
3002: SELECT element_type_id

Line 3003: FROM pay_element_types_f

2999: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
3000: --
3001: CURSOR csr_get_element_type_id IS
3002: SELECT element_type_id
3003: FROM pay_element_types_f
3004: WHERE element_name = p_retro_element_name
3005: AND legislation_code = g_legislation_code;
3006: --
3007: CURSOR csr_exists IS

Line 3076: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3072: IS
3073: --
3074: l_retro_component_usage_id pay_retro_component_usages.retro_component_usage_id%TYPE;
3075: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
3076: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3077: --
3078: CURSOR csr_get_details IS
3079: SELECT c.retro_component_id
3080: , e.element_type_id

Line 3082: , pay_element_types_f e

3078: CURSOR csr_get_details IS
3079: SELECT c.retro_component_id
3080: , e.element_type_id
3081: FROM pay_retro_components c
3082: , pay_element_types_f e
3083: WHERE c.component_name = p_component_name
3084: AND e.element_name = p_creator_name
3085: AND e.legislation_code = g_legislation_code
3086: AND c.legislation_code = g_legislation_code;

Line 3287: CURSOR c_get_recalc_event_group_id (p_element_name pay_element_types_f.element_name%TYPE) IS

3283: WHERE business_group_id is null
3284: AND legislation_code = 'AU'
3285: AND event_group_name = 'AU Retro Enhanced Event Group';
3286:
3287: CURSOR c_get_recalc_event_group_id (p_element_name pay_element_types_f.element_name%TYPE) IS
3288: SELECT count(recalc_event_group_id)
3289: from pay_element_types_f
3290: WHERE business_group_id is null
3291: AND legislation_code = 'AU'

Line 3289: from pay_element_types_f

3285: AND event_group_name = 'AU Retro Enhanced Event Group';
3286:
3287: CURSOR c_get_recalc_event_group_id (p_element_name pay_element_types_f.element_name%TYPE) IS
3288: SELECT count(recalc_event_group_id)
3289: from pay_element_types_f
3290: WHERE business_group_id is null
3291: AND legislation_code = 'AU'
3292: AND element_name = p_element_name;
3293:

Line 3499: update pay_element_types_f

3495: fetch c_get_recalc_event_group_id into l_recalc_eg_count;
3496:
3497: if l_recalc_eg_count = 0 then -- if null
3498:
3499: update pay_element_types_f
3500: set recalc_event_group_id = l_event_group_id
3501: where element_name = 'Statutory Paid Parental Leave Payment';
3502:
3503: end if;

Line 3513: update pay_element_types_f

3509: fetch c_get_recalc_event_group_id into l_recalc_eg_count;
3510:
3511: if l_recalc_eg_count = 0 then -- if null
3512:
3513: update pay_element_types_f
3514: set recalc_event_group_id = l_event_group_id
3515: where element_name = 'Rec Statutory PPL Payment';
3516:
3517: end if;