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 140: from pay_element_types_f

136: ONCE_EACH_PERIOD_FLAG,
137: decode(TIME_DEFINITION_TYPE,'N',NULL,TIME_DEFINITION_TYPE) TIME_DEFINITION_TYPE, /* Bug 5749509*/
138: TIME_DEFINITION_ID,
139: OBJECT_VERSION_NUMBER
140: from pay_element_types_f
141: where element_type_id = p_element_type_id
142: and business_group_id = p_business_group_id
143: ORDER BY effective_start_date;
144:

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

424: WHERE ff.formula_name = 'AU_RETRO_PROCESSED_COUNT'
425: AND ff.legislation_code = 'AU';
426:
427: /* Gets the processing rule id for element */
428: CURSOR c_get_formula_results(c_element_type_id pay_element_types_f.element_type_id%type)
429: IS
430: SELECT pspr.status_processing_rule_id
431: FROM pay_status_processing_rules_f pspr
432: WHERE pspr.business_group_id = p_business_group_id

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

432: WHERE pspr.business_group_id = p_business_group_id
433: AND pspr.element_type_id = c_element_type_id;
434:
435: /* Checks whether formula result rule exist for the element */
436: CURSOR c_get_formula_result_rules(c_element_type_id pay_element_types_f.element_type_id%type,
437: c_result_name pay_formula_result_rules_f.result_name%type,
438: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
439: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
440: IS

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

448: AND DECODE(c_result_rule_type, 'M', '999', pfrr.input_value_id) = DECODE(c_result_rule_type, 'M', '999', c_input_value_id);
449:
450: /* Fetches the input value id for seeded Retropay elements */
451:
452: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
453: IS
454: SELECT DISTINCT pet.element_type_id, piv.input_value_id
455: FROM pay_input_values_f piv,
456: pay_element_types_f pet

Line 456: pay_element_types_f pet

452: CURSOR c_get_input_value_id(c_element_name pay_element_types_f.element_name%type, c_name pay_input_values_f.name%type)
453: IS
454: SELECT DISTINCT pet.element_type_id, piv.input_value_id
455: FROM pay_input_values_f piv,
456: pay_element_types_f pet
457: WHERE pet.element_name = c_element_name
458: AND pet.legislation_code = 'AU'
459: AND piv.element_type_id = pet.element_type_id
460: AND piv.NAME = c_name

Line 1001: from pay_element_types_f

997: RECALC_EVENT_GROUP_ID,
998: ONCE_EACH_PERIOD_FLAG,
999: decode(TIME_DEFINITION_TYPE,'N',NULL,TIME_DEFINITION_TYPE) TIME_DEFINITION_TYPE,
1000: TIME_DEFINITION_ID
1001: from pay_element_types_f
1002: where element_type_id = p_retro_element_id
1003: and business_group_id = p_business_group_id
1004: ORDER BY effective_start_date desc;
1005:

Line 1022: FROM pay_element_types_f pet

1018: /* Checks whether retro element (LT12,GT12...) already exist before creating the element*/
1019: CURSOR c_element_exists
1020: IS
1021: SELECT pet.element_type_id
1022: FROM pay_element_types_f pet
1023: WHERE pet.element_name = rec_element_types.ELEMENT_NAME || ' ' || p_retro_type
1024: AND pet.business_group_id = p_business_group_id;
1025:
1026:

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

1025:
1026:
1027: /* Gets the details of the element link of retro element */
1028: /* 5731490 Fetches all the links associated with retro elements*/
1029: CURSOR c_get_element_links(c_element_type_id pay_element_types_f.element_type_id%type, p_effective_date date)
1030: IS
1031: SELECT pel.PAYROLL_ID,
1032: pel.JOB_ID,
1033: pel.POSITION_ID,

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

1392: -- or LT12 exist whether these elements were created by upgrade process.
1393: -- Procedure sets p_user_element_exist to 'Y' if GT12,LT12 elements were created by user
1394: -- and sets p_upgrade_element_exis to 'Y' if GT12,LT12 elements were created by upgrade process
1395:
1396: Procedure element_exist_check( p_element_type_id in pay_element_types_f.element_type_id%type
1397: ,p_business_group_id in number
1398: ,p_upgrade_element_exist out NOCOPY VARCHAR2
1399: ,p_user_element_exist out NOCOPY VARCHAR2)
1400: is

Line 1403: FROM pay_element_types_f pet1,

1399: ,p_user_element_exist out NOCOPY VARCHAR2)
1400: is
1401: CURSOR c_element_exists IS
1402: SELECT pet2.element_type_id,pet1.element_name,pet2.element_name
1403: FROM pay_element_types_f pet1,
1404: pay_element_types_f pet2
1405: WHERE pet2.element_name in (pet1.element_name || ' '||'GT12' ,
1406: pet1.element_name || ' '||'LT12 Prev',
1407: pet1.element_name || ' '||'LT12 Curr' )

Line 1404: pay_element_types_f pet2

1400: is
1401: CURSOR c_element_exists IS
1402: SELECT pet2.element_type_id,pet1.element_name,pet2.element_name
1403: FROM pay_element_types_f pet1,
1404: pay_element_types_f pet2
1405: WHERE pet2.element_name in (pet1.element_name || ' '||'GT12' ,
1406: pet1.element_name || ' '||'LT12 Prev',
1407: pet1.element_name || ' '||'LT12 Curr' )
1408: AND pet1.business_group_id = p_business_group_id

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

1409: and pet1.business_group_id= pet2.business_group_id
1410: and pet1.element_type_id=p_element_type_id;
1411:
1412:
1413: CURSOR upgraded_element_check(cp_element_type_id pay_element_types_f.element_type_id%type) IS
1414: select 'Y'
1415: from pay_element_type_extra_info
1416: where element_type_id= cp_element_type_id
1417: and information_type='AU_RETRO_UPGRADE_INFO' ;

Line 1419: l_element_type_id pay_element_types_f.element_type_id%type;

1415: from pay_element_type_extra_info
1416: where element_type_id= cp_element_type_id
1417: and information_type='AU_RETRO_UPGRADE_INFO' ;
1418:
1419: l_element_type_id pay_element_types_f.element_type_id%type;
1420: l_upg_element_name pay_element_types_f.element_name%type;
1421: l_retro_element_name pay_element_types_f.element_name%type;
1422: l_upgraded_element char(1);
1423: l_user_element_exist char(1);

Line 1420: l_upg_element_name pay_element_types_f.element_name%type;

1416: where element_type_id= cp_element_type_id
1417: and information_type='AU_RETRO_UPGRADE_INFO' ;
1418:
1419: l_element_type_id pay_element_types_f.element_type_id%type;
1420: l_upg_element_name pay_element_types_f.element_name%type;
1421: l_retro_element_name pay_element_types_f.element_name%type;
1422: l_upgraded_element char(1);
1423: l_user_element_exist char(1);
1424: l_upgrade_element_exist char(1);

Line 1421: l_retro_element_name pay_element_types_f.element_name%type;

1417: and information_type='AU_RETRO_UPGRADE_INFO' ;
1418:
1419: l_element_type_id pay_element_types_f.element_type_id%type;
1420: l_upg_element_name pay_element_types_f.element_name%type;
1421: l_retro_element_name pay_element_types_f.element_name%type;
1422: l_upgraded_element char(1);
1423: l_user_element_exist char(1);
1424: l_upgrade_element_exist char(1);
1425: lv_procedure_name varchar2(30);

Line 1505: from pay_element_types_f pet

1501: pec.classification_name,
1502: pet.retro_summ_ele_id, /* Bug 5731490 */
1503: decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) ||
1504: decode(instr(pec.classification_name, 'Deductions'), 0, null, pec.classification_name ) label
1505: from pay_element_types_f pet
1506: ,pay_element_classifications pec
1507: ,pay_element_classifications pec2
1508: ,pay_sub_classification_rules_f pscr
1509: where pet.element_type_id = cp_element_type_id

Line 1554: pay_element_types_f pet,

1550: and petr.include_or_exclude = 'I'
1551: union all
1552: select pes.element_set_id
1553: from pay_ele_classification_rules pecr,
1554: pay_element_types_f pet,
1555: pay_element_sets pes
1556: where pet.classification_id = pecr.classification_id
1557: and pes.element_set_id = pecr.element_set_id
1558: and (pes.business_group_id = pet.business_group_id

Line 1744: from pay_element_types_f pet,

1740: cursor c_element_dtl(cp_element_type_id in number) is
1741: /* select pet.business_group_id, pet.legislation_code, pet.classification_id,
1742: nvl(pet.retro_summ_ele_id, pet.element_type_id),
1743: pet.element_name, classification_name
1744: from pay_element_types_f pet,
1745: pay_element_classifications pec
1746: where pet.element_type_id = cp_element_type_id
1747: AND pet.classification_id = pec.classification_id
1748: AND pec.legislation_code = 'AU'

Line 1755: FROM pay_element_types_f pet,

1751: nvl(pet.retro_summ_ele_id, pet.element_type_id),
1752: pet.element_name, pec.classification_name
1753: ,pet.retro_summ_ele_id
1754: ,decode(instr(pec.classification_name, 'Earnings'), 0, null,pec2.classification_name) label
1755: FROM pay_element_types_f pet,
1756: pay_element_classifications pec
1757: ,pay_element_classifications pec2
1758: ,pay_sub_classification_rules_f pscr
1759: WHERE pet.element_type_id = cp_element_type_id

Line 1783: pay_element_types_f pet,

1779: and petr.include_or_exclude = 'I'
1780: union all
1781: select pes.element_set_id
1782: from pay_ele_classification_rules pecr,
1783: pay_element_types_f pet,
1784: pay_element_sets pes
1785: where pet.classification_id = pecr.classification_id
1786: and pes.element_set_id = pecr.element_set_id
1787: and (pes.business_group_id = pet.business_group_id

Line 1847: from pay_element_types_f pet1,

1843:
1844: /* Gets the name of the attached retro element */
1845: cursor c_retro_element_name(cp_element_type_id in number) is /* 5461629 */
1846: select pet2.element_name
1847: from pay_element_types_f pet1,
1848: pay_element_types_f pet2
1849: where pet1.element_type_id = cp_element_type_id
1850: AND nvl(pet1.retro_summ_ele_id, pet1.element_type_id) = pet2.element_type_id;
1851:

Line 1848: pay_element_types_f pet2

1844: /* Gets the name of the attached retro element */
1845: cursor c_retro_element_name(cp_element_type_id in number) is /* 5461629 */
1846: select pet2.element_name
1847: from pay_element_types_f pet1,
1848: pay_element_types_f pet2
1849: where pet1.element_type_id = cp_element_type_id
1850: AND nvl(pet1.retro_summ_ele_id, pet1.element_type_id) = pet2.element_type_id;
1851:
1852:

Line 1886: ln_retro_summ_ele_id pay_element_types_f.retro_summ_ele_id%TYPE;

1882: l_user_element_exist char(1);
1883: l_upgrade_element_exist char(1);
1884:
1885: /* Bug 5731490 - Added variables */
1886: ln_retro_summ_ele_id pay_element_types_f.retro_summ_ele_id%TYPE;
1887: lv_class_label varchar2(100);
1888:
1889: l_migrator_mode_status VARCHAR2(2);
1890:

Line 2723: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE

2719: --------------------------------------------------------------------------
2720: PROCEDURE create_element_spans
2721: (p_retro_component_usage_id IN pay_retro_component_usages.retro_component_usage_id%TYPE
2722: ,p_retro_component_id IN pay_retro_components.retro_component_id%TYPE
2723: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE
2724: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2725: )
2726: IS
2727: --

Line 2729: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2725: )
2726: IS
2727: --
2728: l_time_span_id pay_time_spans.time_span_id%TYPE;
2729: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2730: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
2731: --
2732: CURSOR csr_get_element_type_id IS
2733: SELECT element_type_id

Line 2734: FROM pay_element_types_f

2730: l_element_span_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
2731: --
2732: CURSOR csr_get_element_type_id IS
2733: SELECT element_type_id
2734: FROM pay_element_types_f
2735: WHERE element_name = p_retro_element_name
2736: AND legislation_code = g_legislation_code;
2737: --
2738: CURSOR csr_exists IS

Line 2807: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2803: IS
2804: --
2805: l_retro_component_usage_id pay_retro_component_usages.retro_component_usage_id%TYPE;
2806: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
2807: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2808: --
2809: CURSOR csr_get_details IS
2810: SELECT c.retro_component_id
2811: , e.element_type_id

Line 2813: , pay_element_types_f e

2809: CURSOR csr_get_details IS
2810: SELECT c.retro_component_id
2811: , e.element_type_id
2812: FROM pay_retro_components c
2813: , pay_element_types_f e
2814: WHERE c.component_name = p_component_name
2815: AND e.element_name = p_creator_name
2816: AND e.legislation_code = g_legislation_code
2817: AND c.legislation_code = g_legislation_code;