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.HR_LEGISLATION_LOCAL dependencies on PAY_ELEMENT_TYPES_F

Line 73: -- columns of pay_element_types_f table

69: -- (decode_us_element_information and
70: -- translate_us_ele_dev_df) to tranfer the
71: -- balance_type_id and element_type_id
72: -- stored in the element_information*
73: -- columns of pay_element_types_f table
74: -- 115.17 vmehta 26-dec-1999 Changed function install_us_new to
75: -- correctly populate the ids in various
76: -- tables to maintain a history of the
77: -- date-tracked changes in the correct

Line 1273: FROM pay_element_types_f

1269: WHERE element_type_id = p_code;
1270:
1271: CURSOR csr_element_id IS
1272: SELECT element_type_id
1273: FROM pay_element_types_f
1274: WHERE element_name = p_meaning
1275: AND legislation_code = p_legislation_code;
1276:
1277: CURSOR csr_balance_name IS

Line 1351: FROM pay_element_types_f

1347: CURSOR csr_pay_element_details IS
1348: SELECT element_type_id,
1349: element_information_category,
1350: element_information10
1351: FROM pay_element_types_f
1352: WHERE legislation_code = 'US'
1353: AND element_information_category IS NOT NULL
1354: FOR UPDATE OF element_information10 NOWAIT;
1355:

Line 1711: UPDATE pay_element_types_f

1707: LOOP
1708: IF pay_rec.element_information_category = 'US_EARNINGS'
1709: THEN
1710:
1711: UPDATE pay_element_types_f
1712: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1713:
1714: 'BALANCE', NULL, element_information10),
1715: element_information10),

Line 1745: UPDATE pay_element_types_f

1741:
1742: ELSIF pay_rec.element_information_category = 'US_IMPUTED EARNINGS'
1743: THEN
1744:
1745: UPDATE pay_element_types_f
1746: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1747: 'BALANCE'
1748: , NULL, element_information10),
1749: element_information10),

Line 1777: UPDATE pay_element_types_f

1773: -- element_information20)
1774: WHERE element_type_id = pay_rec.element_type_id;
1775:
1776: ELSIF pay_rec.element_information_category = 'US_INVOLUNTARY DEDUCTIONS' THEN
1777: UPDATE pay_element_types_f
1778: SET
1779: --element_information5 = NVL(decode_elmnt_bal_information('US',
1780: -- 'ELEMENT'
1781: -- , NULL, element_information5),

Line 1835: UPDATE pay_element_types_f

1831: WHERE element_type_id = pay_rec.element_type_id;
1832:
1833: ELSIF pay_rec.element_information_category = 'US_NON-PAYROLL PAYMENTS'
1834: THEN
1835: UPDATE pay_element_types_f
1836: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1837: 'BALANCE'
1838: , NULL, element_information10),
1839: element_information10),

Line 1864: UPDATE pay_element_types_f

1860: WHERE element_type_id = pay_rec.element_type_id;
1861:
1862: ELSIF pay_rec.element_information_category = 'US_PRE-TAX DEDUCTIONS'
1863: THEN
1864: UPDATE pay_element_types_f
1865: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1866: 'BALANCE'
1867: , NULL, element_information10),
1868: element_information10),

Line 1913: UPDATE pay_element_types_f

1909: WHERE element_type_id = pay_rec.element_type_id;
1910:
1911: ELSIF pay_rec.element_information_category = 'US_PTO ACCRUALS'
1912: THEN
1913: UPDATE pay_element_types_f
1914: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1915: 'BALANCE'
1916: , NULL, element_information10),
1917: element_information10)

Line 1922: UPDATE pay_element_types_f

1918: WHERE element_type_id = pay_rec.element_type_id;
1919:
1920: ELSIF pay_rec.element_information_category = 'US_SUPPLEMENTAL EARNINGS'
1921: THEN
1922: UPDATE pay_element_types_f
1923: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1924: 'BALANCE'
1925: , NULL, element_information10),
1926: element_information10),

Line 1955: UPDATE pay_element_types_f

1951: WHERE element_type_id = pay_rec.element_type_id;
1952:
1953: ELSIF pay_rec.element_information_category = 'US_TAX DEDUCTIONS'
1954: THEN
1955: UPDATE pay_element_types_f
1956: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1957: 'BALANCE'
1958: , NULL, element_information10),
1959: element_information10),

Line 2000: UPDATE pay_element_types_f

1996: WHERE element_type_id = pay_rec.element_type_id;
1997:
1998: ELSIF pay_rec.element_information_category = 'US_VOLUNTARY DEDUCTIONS'
1999: THEN
2000: UPDATE pay_element_types_f
2001: SET element_information10 = NVL(decode_elmnt_bal_information('US',
2002: 'BALANCE'
2003: , NULL, element_information10),
2004: element_information10),

Line 2067: FROM pay_element_types_f

2063: CURSOR csr_pay_element_details IS
2064: SELECT element_type_id,
2065: element_information_category,
2066: element_information10
2067: FROM pay_element_types_f
2068: WHERE legislation_code = 'CA'
2069: AND element_information_category IS NOT NULL
2070: FOR UPDATE OF element_information10 NOWAIT;
2071:

Line 2212: UPDATE pay_element_types_f

2208: LOOP
2209: IF pay_rec.element_information_category = 'CA_EARNINGS'
2210: THEN
2211:
2212: UPDATE pay_element_types_f
2213: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2214: 'BALANCE', NULL, element_information10),
2215: element_information10),
2216: element_information12 = NVL(decode_elmnt_bal_information('CA',

Line 2224: UPDATE pay_element_types_f

2220:
2221: ELSIF pay_rec.element_information_category = 'CA_TAXABLE BENEFITS'
2222: THEN
2223:
2224: UPDATE pay_element_types_f
2225: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2226: 'BALANCE'
2227: , NULL, element_information10),
2228: element_information10),

Line 2237: UPDATE pay_element_types_f

2233: WHERE element_type_id = pay_rec.element_type_id;
2234:
2235: ELSIF pay_rec.element_information_category = 'CA_INVOLUNTARY DEDUCTIONS'
2236: THEN
2237: UPDATE pay_element_types_f
2238: SET
2239: element_information10 = NVL(decode_elmnt_bal_information('CA',
2240: 'BALANCE'
2241: , NULL, element_information10),

Line 2271: UPDATE pay_element_types_f

2267: WHERE element_type_id = pay_rec.element_type_id;
2268:
2269: ELSIF pay_rec.element_information_category = 'CA_NON-PAYROLL PAYMENTS'
2270: THEN
2271: UPDATE pay_element_types_f
2272: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2273: 'BALANCE'
2274: , NULL, element_information10),
2275: element_information10)

Line 2280: UPDATE pay_element_types_f

2276: WHERE element_type_id = pay_rec.element_type_id;
2277:
2278: ELSIF pay_rec.element_information_category = 'CA_PRE-TAX DEDUCTIONS'
2279: THEN
2280: UPDATE pay_element_types_f
2281: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2282: 'BALANCE'
2283: , NULL, element_information10),
2284: element_information10),

Line 2302: UPDATE pay_element_types_f

2298:
2299:
2300: ELSIF pay_rec.element_information_category = 'CA_SUPPLEMENTAL EARNINGS'
2301: THEN
2302: UPDATE pay_element_types_f
2303: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2304: 'BALANCE'
2305: , NULL, element_information10),
2306: element_information10),

Line 2316: UPDATE pay_element_types_f

2312:
2313:
2314: ELSIF pay_rec.element_information_category = 'CA_VOLUNTARY DEDUCTIONS'
2315: THEN
2316: UPDATE pay_element_types_f
2317: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2318: 'BALANCE'
2319: , NULL, element_information10),
2320: element_information10),