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 HR_S_ELEMENT_TYPES_F

Line 1268: FROM hr_s_element_types_f

1264: RETURN VARCHAR2 IS
1265:
1266: CURSOR csr_element_name IS
1267: SELECT element_name
1268: FROM hr_s_element_types_f
1269: WHERE element_type_id = p_code;
1270:
1271: CURSOR csr_element_id IS
1272: SELECT element_type_id

Line 1342: FROM hr_s_element_types_f

1338: CURSOR csr_hr_s_element_details IS
1339: SELECT element_type_id,
1340: element_information_category,
1341: element_information10
1342: FROM hr_s_element_types_f
1343: WHERE legislation_code = 'US'
1344: AND element_information_category IS NOT NULL
1345: FOR UPDATE OF element_information10 NOWAIT;
1346:

Line 1371: UPDATE hr_s_element_types_f

1367: LOOP
1368: IF hr_s_rec.element_information_category = 'US_EARNINGS'
1369: THEN
1370:
1371: UPDATE hr_s_element_types_f
1372: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1373: 'BALANCE'
1374: , element_information10, NULL),
1375: element_information10),

Line 1405: UPDATE hr_s_element_types_f

1401:
1402: ELSIF hr_s_rec.element_information_category = 'US_IMPUTED EARNINGS'
1403: THEN
1404:
1405: UPDATE hr_s_element_types_f
1406: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1407: 'BALANCE'
1408: , element_information10, NULL),
1409: element_information10),

Line 1437: UPDATE hr_s_element_types_f

1433: -- element_information20)
1434: WHERE element_type_id = hr_s_rec.element_type_id;
1435:
1436: ELSIF hr_s_rec.element_information_category = 'US_INVOLUNTARY DEDUCTIONS' THEN
1437: UPDATE hr_s_element_types_f
1438: SET
1439: -- element_information5 = NVL(decode_elmnt_bal_information('US',
1440: -- 'ELEMENT'
1441: -- , element_information5, NULL),

Line 1495: UPDATE hr_s_element_types_f

1491: WHERE element_type_id = hr_s_rec.element_type_id;
1492:
1493: ELSIF hr_s_rec.element_information_category = 'US_NON-PAYROLL PAYMENTS'
1494: THEN
1495: UPDATE hr_s_element_types_f
1496: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1497: 'BALANCE'
1498: , element_information10, NULL),
1499: element_information10),

Line 1524: UPDATE hr_s_element_types_f

1520: WHERE element_type_id = hr_s_rec.element_type_id;
1521:
1522: ELSIF hr_s_rec.element_information_category = 'US_PRE-TAX DEDUCTIONS'
1523: THEN
1524: UPDATE hr_s_element_types_f
1525: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1526: 'BALANCE'
1527: , element_information10, NULL),
1528: element_information10),

Line 1573: UPDATE hr_s_element_types_f

1569: WHERE element_type_id = hr_s_rec.element_type_id;
1570:
1571: ELSIF hr_s_rec.element_information_category = 'US_PTO ACCRUALS'
1572: THEN
1573: UPDATE hr_s_element_types_f
1574: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1575: 'BALANCE'
1576: , element_information10, NULL),
1577: element_information10)

Line 1582: UPDATE hr_s_element_types_f

1578: WHERE element_type_id = hr_s_rec.element_type_id;
1579:
1580: ELSIF hr_s_rec.element_information_category = 'US_SUPPLEMENTAL EARNINGS'
1581: THEN
1582: UPDATE hr_s_element_types_f
1583: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1584: 'BALANCE'
1585: , element_information10, NULL),
1586: element_information10),

Line 1615: UPDATE hr_s_element_types_f

1611: WHERE element_type_id = hr_s_rec.element_type_id;
1612:
1613: ELSIF hr_s_rec.element_information_category = 'US_TAX DEDUCTIONS'
1614: THEN
1615: UPDATE hr_s_element_types_f
1616: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1617: 'BALANCE'
1618: , element_information10, NULL),
1619: element_information10),

Line 1660: UPDATE hr_s_element_types_f

1656: WHERE element_type_id = hr_s_rec.element_type_id;
1657:
1658: ELSIF hr_s_rec.element_information_category = 'US_VOLUNTARY DEDUCTIONS'
1659: THEN
1660: UPDATE hr_s_element_types_f
1661: SET element_information10 = NVL(decode_elmnt_bal_information('US',
1662: 'BALANCE'
1663: , element_information10, NULL),
1664: element_information10),

Line 2058: FROM hr_s_element_types_f

2054: CURSOR csr_hr_s_element_details IS
2055: SELECT element_type_id,
2056: element_information_category,
2057: element_information10
2058: FROM hr_s_element_types_f
2059: WHERE legislation_code = 'CA'
2060: AND element_information_category IS NOT NULL
2061: FOR UPDATE OF element_information10 NOWAIT;
2062:

Line 2079: UPDATE hr_s_element_types_f

2075: LOOP
2076: IF hr_s_rec.element_information_category = 'CA_EARNINGS'
2077: THEN
2078: --
2079: UPDATE hr_s_element_types_f
2080: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2081: 'BALANCE'
2082: , element_information10, NULL),
2083: element_information10),

Line 2093: UPDATE hr_s_element_types_f

2089:
2090: ELSIF hr_s_rec.element_information_category = 'CA_TAXABLE BENEFITS'
2091: THEN
2092:
2093: UPDATE hr_s_element_types_f
2094: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2095: 'BALANCE'
2096: , element_information10, NULL),
2097: element_information10),

Line 2106: UPDATE hr_s_element_types_f

2102: WHERE element_type_id = hr_s_rec.element_type_id;
2103:
2104: ELSIF hr_s_rec.element_information_category = 'CA_INVOLUNTARY DEDUCTIONS'
2105: THEN
2106: UPDATE hr_s_element_types_f
2107: SET
2108: element_information10 = NVL(decode_elmnt_bal_information('CA',
2109: 'BALANCE'
2110: , element_information10, NULL),

Line 2140: UPDATE hr_s_element_types_f

2136: WHERE element_type_id = hr_s_rec.element_type_id;
2137:
2138: ELSIF hr_s_rec.element_information_category = 'CA_NON-PAYROLL PAYMENTS'
2139: THEN
2140: UPDATE hr_s_element_types_f
2141: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2142: 'BALANCE'
2143: , element_information10, NULL),
2144: element_information10)

Line 2149: UPDATE hr_s_element_types_f

2145: WHERE element_type_id = hr_s_rec.element_type_id;
2146:
2147: ELSIF hr_s_rec.element_information_category = 'CA_PRE-TAX DEDUCTIONS'
2148: THEN
2149: UPDATE hr_s_element_types_f
2150: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2151: 'BALANCE'
2152: , element_information10, NULL),
2153: element_information10),

Line 2171: UPDATE hr_s_element_types_f

2167:
2168:
2169: ELSIF hr_s_rec.element_information_category = 'CA_SUPPLEMENTAL EARNINGS'
2170: THEN
2171: UPDATE hr_s_element_types_f
2172: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2173: 'BALANCE'
2174: , element_information10, NULL),
2175: element_information10),

Line 2185: UPDATE hr_s_element_types_f

2181:
2182:
2183: ELSIF hr_s_rec.element_information_category = 'CA_VOLUNTARY DEDUCTIONS'
2184: THEN
2185: UPDATE hr_s_element_types_f
2186: SET element_information10 = NVL(decode_elmnt_bal_information('CA',
2187: 'BALANCE'
2188: , element_information10, NULL),
2189: element_information10),