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 248: pay_element_types_f pet,

244: -- Cursor to get classification of elements.
245: cursor csr_ele_classification is
246: select classification_name
247: from pay_element_classifications pec,
248: pay_element_types_f pet,
249: pay_element_entries_f pee
250: where pec.classification_id = pet.classification_id
251: and pet.element_type_id = pee.element_type_id
252: and pee.element_entry_id = p_ee_id;

Line 1075: FROM pay_element_types_f

1071: AND legislation_code = 'US';
1072:
1073: CURSOR c_ele (p_element_name IN VARCHAR2) IS
1074: SELECT element_type_id
1075: FROM pay_element_types_f
1076: WHERE UPPER (element_name) = UPPER (p_element_name)
1077: AND legislation_code = 'US';
1078:
1079: CURSOR c_inp_val(p_input_val_name IN VARCHAR2, p_element_type_id IN NUMBER)

Line 1211: UPDATE pay_element_types_f

1207: 'ELE',
1208: lrec.element_name || ' Special Features'
1209: );
1210:
1211: UPDATE pay_element_types_f
1212: SET element_name = lrec.element_name,
1213: element_information10 = l_pri_bal_id,
1214: element_information12 = l_hours_bal_id
1215: WHERE element_type_id = pay_us_earn_templ_wrapper.g_ele_type_id

Line 1237: UPDATE pay_element_types_f

1233: 'ELE',
1234: lrec.element_name || ' for FLSA Calc'
1235: );
1236: /*
1237: UPDATE pay_element_types_f
1238: SET element_information10 = l_fc_bal_id
1239: WHERE element_type_id = l_fc_ele_type_id
1240: AND business_group_id = ln_business_group_id;
1241: */

Line 1278: UPDATE pay_element_types_f

1274: OPEN get_proration_group_id(ln_proration_group_name,NULL,NULL);
1275: FETCH get_proration_group_id INTO ln_proration_group_id;
1276: CLOSE get_proration_group_id;
1277:
1278: UPDATE pay_element_types_f
1279: SET element_information10 = l_fpa_bal_id,
1280: element_information12 = l_fpa_hrs_bal_id,
1281: proration_group_id = ln_proration_group_id
1282: WHERE element_type_id = l_fpa_ele_type_id

Line 1518: UPDATE pay_element_types_f

1514: OPEN get_proration_group_id(ln_proration_group_name,NULL,NULL);
1515: FETCH get_proration_group_id INTO ln_proration_group_id;
1516: IF get_proration_group_id%FOUND THEN
1517: /*Updating for FLSA Calc Element with proration group id*/
1518: UPDATE pay_element_types_f
1519: SET proration_group_id = ln_proration_group_id
1520: WHERE business_group_id = ln_business_group_id
1521: AND element_type_id = l_fc_ele_type_id;
1522: ELSE

Line 1534: UPDATE pay_element_types_f

1530: OPEN get_proration_group_id(ln_proration_group_name,NULL,NULL);
1531: FETCH get_proration_group_id INTO ln_proration_group_id;
1532: IF get_proration_group_id%FOUND THEN
1533: /*Updating for FLSA Calc Element with retro group id*/
1534: UPDATE pay_element_types_f
1535: SET recalc_event_group_id = ln_proration_group_id
1536: WHERE business_group_id = ln_business_group_id
1537: AND element_type_id = l_fc_ele_type_id;
1538:

Line 1659: UPDATE pay_element_types_f

1655: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1656: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1657: IF (lrec.configuration_information10 = 'N') then
1658: hr_utility.trace('1. Updating Time Definition Type to G');
1659: UPDATE pay_element_types_f
1660: SET time_definition_type = 'G'
1661: WHERE business_group_id = ln_business_group_id
1662: AND element_type_id in ( pay_us_earn_templ_wrapper.g_ele_type_id
1663: ,l_fpa_ele_type_id);

Line 1667: UPDATE pay_element_types_f

1663: ,l_fpa_ele_type_id);
1664: END IF;
1665: ELSIF lrec.configuration_information7 = 'Y' THEN
1666: hr_utility.trace('2. Updating Time Definition Type to G');
1667: UPDATE pay_element_types_f
1668: SET time_definition_type = 'G'
1669: WHERE business_group_id = ln_business_group_id
1670: AND element_type_id = pay_us_earn_templ_wrapper.g_ele_type_id;
1671: END IF;

Line 1676: UPDATE pay_element_types_f

1672:
1673: -- Modifying the TIME_DEFINTION_TYPE for Augment elements to 'G'
1674: IF ((lrec.calculation_rule = 'US ' || lrec.element_classification) AND lrec.configuration_information24 = 'Y') THEN
1675: hr_utility.trace('2. Updating Time Definition Type to G');
1676: UPDATE pay_element_types_f
1677: SET time_definition_type = 'G'
1678: WHERE business_group_id = ln_business_group_id
1679: AND element_type_id = l_fc_ele_type_id;
1680: END IF;

Line 1693: lv_ele_name pay_element_types_f.element_name%TYPE;

1689:
1690: PROCEDURE delete_pre_process(p_element_template_id IN NUMBER) IS
1691:
1692: i NUMBER;
1693: lv_ele_name pay_element_types_f.element_name%TYPE;
1694: lv_business_group_id NUMBER;
1695: lv_legislation_code VARCHAR2 (240);
1696: l_shadow_ele_type_id NUMBER;
1697: l_spr_id NUMBER;

Line 1708: v_shadow_ele_name pay_element_types_f.element_name%TYPE

1704: l_eff_end_date DATE;
1705:
1706: TYPE ushadowrec IS RECORD
1707: (
1708: v_shadow_ele_name pay_element_types_f.element_name%TYPE
1709: );
1710:
1711: TYPE ushadowrectab IS TABLE OF ushadowrec
1712: INDEX BY BINARY_INTEGER;

Line 1720: FROM pay_element_types_f

1716: CURSOR c_ele_name (p_element_type_id IN NUMBER) IS
1717: SELECT element_name
1718: , business_group_id
1719: , legislation_code
1720: FROM pay_element_types_f
1721: WHERE element_type_id = p_element_type_id;
1722:
1723: CURSOR c_stat_proc_rule ( p_element_type_id IN NUMBER
1724: ,p_business_group_id IN NUMBER

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

1828: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1829:
1830: ELSE
1831: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1832: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1833: END IF;/*c_ele_name%FOUND*/
1834: CLOSE c_ele_name;
1835:
1836: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');

Line 1870: FROM pay_element_types_f

1866:
1867: --
1868: CURSOR c_element IS -- Gets the element type id
1869: SELECT element_type_id
1870: FROM pay_element_types_f
1871: WHERE element_name = p_object_name
1872: AND business_group_id = p_business_group_id;
1873:
1874: --

Line 2154: FROM pay_element_types_f pet,

2150: ,cp_bus_grp NUMBER
2151: ,cp_date DATE
2152: ) IS
2153: SELECT element_name
2154: FROM pay_element_types_f pet,
2155: pay_element_entries_f pee
2156: WHERE pee.element_entry_id = cp_element_entry
2157: AND pee.element_type_id = pet.element_type_id
2158: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)

Line 2307: FROM pay_element_types_f pet,

2303: ,cp_assignment_id NUMBER
2304: ,cp_date DATE
2305: ) IS
2306: SELECT peev.screen_entry_value
2307: FROM pay_element_types_f pet,
2308: pay_input_values_f piv,
2309: pay_element_entries_f peef,
2310: pay_element_entry_values_f peev
2311: WHERE pet.element_name = cp_ele_name

Line 2373: FROM pay_element_types_f pet,

2369: ,cp_bus_grp NUMBER
2370: ,cp_date DATE
2371: ) IS
2372: SELECT element_name
2373: FROM pay_element_types_f pet,
2374: pay_element_entries_f pee
2375: WHERE pee.element_entry_id = cp_element_entry
2376: AND pee.element_type_id = pet.element_type_id
2377: AND ((pet.legislation_code = 'US' and pet.business_group_id is null)