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_US_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 193: pay_element_types_f pet,

189: -- Cursor to get classification of elements.
190: cursor csr_ele_classification is
191: select classification_name
192: from pay_element_classifications pec,
193: pay_element_types_f pet,
194: pay_element_entries_f pee
195: where pec.classification_id = pet.classification_id
196: and pet.element_type_id = pee.element_type_id
197: and pee.element_entry_id = p_ee_id;

Line 1020: FROM pay_element_types_f

1016: AND legislation_code = 'US';
1017:
1018: CURSOR c_ele (p_element_name IN VARCHAR2) IS
1019: SELECT element_type_id
1020: FROM pay_element_types_f
1021: WHERE UPPER (element_name) = UPPER (p_element_name)
1022: AND legislation_code = 'US';
1023:
1024: CURSOR c_inp_val(p_input_val_name IN VARCHAR2, p_element_type_id IN NUMBER)

Line 1156: UPDATE pay_element_types_f

1152: 'ELE',
1153: lrec.element_name || ' Special Features'
1154: );
1155:
1156: UPDATE pay_element_types_f
1157: SET element_name = lrec.element_name,
1158: element_information10 = l_pri_bal_id,
1159: element_information12 = l_hours_bal_id
1160: WHERE element_type_id = pay_us_earn_templ_wrapper.g_ele_type_id

Line 1182: UPDATE pay_element_types_f

1178: 'ELE',
1179: lrec.element_name || ' for FLSA Calc'
1180: );
1181: /*
1182: UPDATE pay_element_types_f
1183: SET element_information10 = l_fc_bal_id
1184: WHERE element_type_id = l_fc_ele_type_id
1185: AND business_group_id = ln_business_group_id;
1186: */

Line 1223: UPDATE pay_element_types_f

1219: OPEN get_proration_group_id(ln_proration_group_name,NULL,NULL);
1220: FETCH get_proration_group_id INTO ln_proration_group_id;
1221: CLOSE get_proration_group_id;
1222:
1223: UPDATE pay_element_types_f
1224: SET element_information10 = l_fpa_bal_id,
1225: element_information12 = l_fpa_hrs_bal_id,
1226: proration_group_id = ln_proration_group_id
1227: WHERE element_type_id = l_fpa_ele_type_id

Line 1463: UPDATE pay_element_types_f

1459: OPEN get_proration_group_id(ln_proration_group_name,NULL,NULL);
1460: FETCH get_proration_group_id INTO ln_proration_group_id;
1461: IF get_proration_group_id%FOUND THEN
1462: /*Updating for FLSA Calc Element with proration group id*/
1463: UPDATE pay_element_types_f
1464: SET proration_group_id = ln_proration_group_id
1465: WHERE business_group_id = ln_business_group_id
1466: AND element_type_id = l_fc_ele_type_id;
1467: ELSE

Line 1479: UPDATE pay_element_types_f

1475: OPEN get_proration_group_id(ln_proration_group_name,NULL,NULL);
1476: FETCH get_proration_group_id INTO ln_proration_group_id;
1477: IF get_proration_group_id%FOUND THEN
1478: /*Updating for FLSA Calc Element with retro group id*/
1479: UPDATE pay_element_types_f
1480: SET recalc_event_group_id = ln_proration_group_id
1481: WHERE business_group_id = ln_business_group_id
1482: AND element_type_id = l_fc_ele_type_id;
1483:

Line 1604: UPDATE pay_element_types_f

1600: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1601: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1602: IF (lrec.configuration_information10 = 'N') then
1603: hr_utility.trace('1. Updating Time Definition Type to G');
1604: UPDATE pay_element_types_f
1605: SET time_definition_type = 'G'
1606: WHERE business_group_id = ln_business_group_id
1607: AND element_type_id in ( pay_us_earn_templ_wrapper.g_ele_type_id
1608: ,l_fpa_ele_type_id);

Line 1612: UPDATE pay_element_types_f

1608: ,l_fpa_ele_type_id);
1609: END IF;
1610: ELSIF lrec.configuration_information7 = 'Y' THEN
1611: hr_utility.trace('2. Updating Time Definition Type to G');
1612: UPDATE pay_element_types_f
1613: SET time_definition_type = 'G'
1614: WHERE business_group_id = ln_business_group_id
1615: AND element_type_id = pay_us_earn_templ_wrapper.g_ele_type_id;
1616: END IF;

Line 1621: UPDATE pay_element_types_f

1617:
1618: -- Modifying the TIME_DEFINTION_TYPE for Augment elements to 'G'
1619: IF ((lrec.calculation_rule = 'US ' || lrec.element_classification) AND lrec.configuration_information24 = 'Y') THEN
1620: hr_utility.trace('2. Updating Time Definition Type to G');
1621: UPDATE pay_element_types_f
1622: SET time_definition_type = 'G'
1623: WHERE business_group_id = ln_business_group_id
1624: AND element_type_id = l_fc_ele_type_id;
1625: END IF;

Line 1638: lv_ele_name pay_element_types_f.element_name%TYPE;

1634:
1635: PROCEDURE delete_pre_process(p_element_template_id IN NUMBER) IS
1636:
1637: i NUMBER;
1638: lv_ele_name pay_element_types_f.element_name%TYPE;
1639: lv_business_group_id NUMBER;
1640: lv_legislation_code VARCHAR2 (240);
1641: l_shadow_ele_type_id NUMBER;
1642: l_spr_id NUMBER;

Line 1653: v_shadow_ele_name pay_element_types_f.element_name%TYPE

1649: l_eff_end_date DATE;
1650:
1651: TYPE ushadowrec IS RECORD
1652: (
1653: v_shadow_ele_name pay_element_types_f.element_name%TYPE
1654: );
1655:
1656: TYPE ushadowrectab IS TABLE OF ushadowrec
1657: INDEX BY BINARY_INTEGER;

Line 1665: FROM pay_element_types_f

1661: CURSOR c_ele_name (p_element_type_id IN NUMBER) IS
1662: SELECT element_name
1663: , business_group_id
1664: , legislation_code
1665: FROM pay_element_types_f
1666: WHERE element_type_id = p_element_type_id;
1667:
1668: CURSOR c_stat_proc_rule ( p_element_type_id IN NUMBER
1669: ,p_business_group_id IN NUMBER

Line 1777: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');

1773: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1774:
1775: ELSE
1776: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1777: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1778: END IF;/*c_ele_name%FOUND*/
1779: CLOSE c_ele_name;
1780:
1781: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');

Line 1815: FROM pay_element_types_f

1811:
1812: --
1813: CURSOR c_element IS -- Gets the element type id
1814: SELECT element_type_id
1815: FROM pay_element_types_f
1816: WHERE element_name = p_object_name
1817: AND business_group_id = p_business_group_id;
1818:
1819: --

Line 2094: FROM pay_element_types_f pet,

2090: ,cp_bus_grp NUMBER
2091: ,cp_date DATE
2092: ) IS
2093: SELECT element_name
2094: FROM pay_element_types_f pet,
2095: pay_element_entries_f pee
2096: WHERE pee.element_entry_id = cp_element_entry
2097: AND pee.element_type_id = pet.element_type_id
2098: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)

Line 2247: FROM pay_element_types_f pet,

2243: ,cp_assignment_id NUMBER
2244: ,cp_date DATE
2245: ) IS
2246: SELECT peev.screen_entry_value
2247: FROM pay_element_types_f pet,
2248: pay_input_values_f piv,
2249: pay_element_entries_f peef,
2250: pay_element_entry_values_f peev
2251: WHERE pet.element_name = cp_ele_name

Line 2313: FROM pay_element_types_f pet,

2309: ,cp_bus_grp NUMBER
2310: ,cp_date DATE
2311: ) IS
2312: SELECT element_name
2313: FROM pay_element_types_f pet,
2314: pay_element_entries_f pee
2315: WHERE pee.element_entry_id = cp_element_entry
2316: AND pee.element_type_id = pet.element_type_id
2317: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)