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_BALANCES dependencies on PAY_BALANCE_FEEDS

Line 34: PAY_BALANCE_FEEDS_F

30: --
31: PAY_ELEMENT_TYPES_F
32: PAY_INPUT_VALUES_F
33: PAY_SUB_CLASSIFICATION_RULES_F
34: PAY_BALANCE_FEEDS_F
35: PAY_BALANCE_TYPES
36: PAY_BALANCE_CLASSIFCIATIONS
37: PAY_DEFINED_BALANCES
38: --

Line 211: pay_balance_feeds_s.nextval a_balance_feed_id,

207: -- Declare local cursors
208: --
209: CURSOR cur_get_pay_pay_value IS
210: SELECT /*+ INDEX (BT PAY_BALANCE_TYPES_PK) */
211: pay_balance_feeds_s.nextval a_balance_feed_id,
212: iv.effective_start_date a_effective_start_date,
213: iv.effective_end_date a_effective_end_date,
214: iv.input_value_id a_input_value_id,
215: bc.balance_type_id a_balance_type_id,

Line 245: FROM pay_balance_feeds_f feed,

241: FOR UPDATE;
242: --
243: CURSOR cur_check_pay_pay_value IS
244: SELECT feed.balance_feed_id
245: FROM pay_balance_feeds_f feed,
246: pay_balance_types bt,
247: pay_balance_classifications bc,
248: pay_element_types_f et,
249: pay_input_values_f iv

Line 271: pay_balance_feeds_s.nextval a_balance_feed_id,

267: AND feed.effective_end_date >= iv.effective_start_date;
268: --
269: CURSOR cur_get_per_pay_value_prim IS
270: SELECT /*+ INDEX (BT PAY_BALANCE_TYPES_PK) */
271: pay_balance_feeds_s.nextval a_balance_feed_id,
272: iv.effective_start_date a_effective_start_date,
273: iv.effective_end_date a_effective_end_date,
274: iv.input_value_id a_input_value_id,
275: bc.balance_type_id a_balance_type_id,

Line 305: FROM pay_balance_feeds_f feed,

301: FOR UPDATE;
302: --
303: CURSOR cur_check_per_pay_value_prim IS
304: SELECT feed.balance_feed_id
305: FROM pay_balance_feeds_f feed,
306: pay_balance_types bt,
307: pay_balance_classifications bc,
308: pay_element_types_f et,
309: pay_input_values_f iv

Line 331: pay_balance_feeds_s.nextval a_balance_feed_id,

327: AND feed.effective_end_date >= iv.effective_start_date;
328: --
329: CURSOR cur_get_per_pay_value_sub IS
330: SELECT /*+ INDEX (BT PAY_BALANCE_TYPES_PK) */
331: pay_balance_feeds_s.nextval a_balance_feed_id,
332: scr.effective_start_date a_effective_start_date,
333: scr.effective_end_date a_effective_end_date,
334: iv.input_value_id a_input_value_id,
335: bc.balance_type_id a_balance_type_id,

Line 369: FROM pay_balance_feeds_f feed,

365: FOR UPDATE;
366: --
367: CURSOR cur_check_per_pay_value_sub IS
368: SELECT feed.balance_feed_id
369: FROM pay_balance_feeds_f feed,
370: pay_balance_types bt,
371: pay_balance_classifications bc,
372: pay_element_types_f et,
373: pay_sub_classification_rules_f scr,

Line 416: FROM pay_balance_feeds_f feed,

412: OR bt.balance_uom <> 'M');
413: --
414: CURSOR cur_check_manual_feed IS
415: SELECT feed.balance_feed_id
416: FROM pay_balance_feeds_f feed,
417: pay_balance_types bt,
418: pay_element_types_f et,
419: pay_input_values_f iv
420: WHERE iv.input_value_id = p_input_value_id

Line 471: FROM pay_balance_feeds feed,

467: FOR UPDATE;
468: --
469: CURSOR cur_check_sub_class_rule IS
470: SELECT feed.balance_feed_id
471: FROM pay_balance_feeds feed,
472: pay_balance_types bt,
473: pay_balance_classifications bc,
474: pay_element_types_f et,
475: pay_input_values_f_tl iv_tl,

Line 535: SELECT pay_balance_feeds_s.nextval a_balance_feed_id,

531: AND et.effective_end_date >= p_session_date;
532: --
533: CURSOR cur_bt_sub_class_rule (c_uom varchar2,
534: c_output_currency_code varchar2) IS
535: SELECT pay_balance_feeds_s.nextval a_balance_feed_id,
536: bc.balance_type_id a_balance_type_id,
537: bc.scale a_scale,
538: bc.last_updated_by a_last_updated_by,
539: bc.last_update_login a_last_update_login,

Line 585: FROM pay_balance_feeds_f feed,

581: FOR UPDATE;
582: --
583: CURSOR cur_check_primary_bal_class IS
584: SELECT feed.balance_feed_id
585: FROM pay_balance_feeds_f feed,
586: pay_balance_types bt,
587: pay_input_values_f_tl iv_tl,
588: pay_input_values_f iv,
589: pay_element_types_f et

Line 684: FROM pay_balance_feeds_f feed,

680: FOR UPDATE;
681: --
682: CURSOR cur_check_sub_bal_class IS
683: SELECT feed.balance_feed_id
684: FROM pay_balance_feeds_f feed,
685: pay_balance_types bt,
686: pay_element_types_f et,
687: pay_input_values_f_tl iv_tl,
688: pay_input_values_f iv,

Line 793: INSERT INTO pay_balance_feeds_f

789: hr_utility.set_location('INS_PAY_PAY_VALUE', 4);
790: --
791: FOR get_rec IN cur_get_pay_pay_value LOOP
792: --
793: INSERT INTO pay_balance_feeds_f
794: (balance_feed_id,
795: effective_start_date,
796: effective_end_date,
797: input_value_id,

Line 879: INSERT INTO pay_balance_feeds_f

875: hr_utility.set_location('INS_PER_PAY_VALUE', 4);
876: --
877: FOR get_rec IN cur_get_per_pay_value_prim LOOP
878: --
879: INSERT INTO pay_balance_feeds_f
880: (balance_feed_id,
881: effective_start_date,
882: effective_end_date,
883: input_value_id,

Line 947: INSERT INTO pay_balance_feeds_f

943: hr_utility.set_location('INS_PER_PAY_VALUE', 7);
944: --
945: FOR get_rec IN cur_get_per_pay_value_sub LOOP
946: --
947: INSERT INTO pay_balance_feeds_f
948: (balance_feed_id,
949: effective_start_date,
950: effective_end_date,
951: input_value_id,

Line 1030: SELECT pay_balance_feeds_s.nextval

1026: IF p_session_date is not NULL THEN
1027: --
1028: hr_utility.set_location('INS_MANUAL_FEED', 4);
1029: --
1030: SELECT pay_balance_feeds_s.nextval
1031: INTO v_sequence
1032: FROM sys.dual;
1033: --
1034: INSERT INTO pay_balance_feeds_f

Line 1034: INSERT INTO pay_balance_feeds_f

1030: SELECT pay_balance_feeds_s.nextval
1031: INTO v_sequence
1032: FROM sys.dual;
1033: --
1034: INSERT INTO pay_balance_feeds_f
1035: (balance_feed_id,
1036: effective_start_date,
1037: effective_end_date,
1038: input_value_id,

Line 1139: INSERT INTO pay_balance_feeds_f

1135: (iv_rec.a_uom, iv_rec.a_output_currency_code) LOOP
1136: --
1137: hr_utility.set_location('INS_SUB_CLASS_RULE', 6);
1138: --
1139: INSERT INTO pay_balance_feeds_f
1140: (balance_feed_id,
1141: effective_start_date,
1142: effective_end_date,
1143: input_value_id,

Line 1231: SELECT pay_balance_feeds_s.nextval

1227: --
1228: EXIT bal_loop WHEN iv_rec.a_effective_start_date IS NULL
1229: OR iv_rec.a_effective_end_date IS NULL;
1230: --
1231: SELECT pay_balance_feeds_s.nextval
1232: INTO v_sequence
1233: FROM sys.dual;
1234: --
1235: INSERT INTO pay_balance_feeds_f

Line 1235: INSERT INTO pay_balance_feeds_f

1231: SELECT pay_balance_feeds_s.nextval
1232: INTO v_sequence
1233: FROM sys.dual;
1234: --
1235: INSERT INTO pay_balance_feeds_f
1236: (balance_feed_id,
1237: effective_start_date,
1238: effective_end_date,
1239: input_value_id,

Line 1316: SELECT pay_balance_feeds_s.nextval

1312: hr_utility.set_location('INS_SUB_BAL_CLASS', 4);
1313: --
1314: FOR iv_rec IN cur_iv_sub_bal_class LOOP
1315: --
1316: SELECT pay_balance_feeds_s.nextval
1317: INTO v_sequence
1318: FROM sys.dual;
1319: --
1320: INSERT INTO pay_balance_feeds_f

Line 1320: INSERT INTO pay_balance_feeds_f

1316: SELECT pay_balance_feeds_s.nextval
1317: INTO v_sequence
1318: FROM sys.dual;
1319: --
1320: INSERT INTO pay_balance_feeds_f
1321: (balance_feed_id,
1322: effective_start_date,
1323: effective_end_date,
1324: input_value_id,

Line 1406: SELECT pay_balance_feeds_s.nextval

1402: IF p_session_date is not NULL THEN
1403: --
1404: hr_utility.set_location('INS_PRIMARY_BALANCE_FEED', 4);
1405: --
1406: SELECT pay_balance_feeds_s.nextval
1407: INTO v_sequence
1408: FROM sys.dual;
1409: --
1410: hr_utility.set_location('INS_PRIMARY_BALANCE_FEED', 5);

Line 1412: INSERT INTO pay_balance_feeds_f

1408: FROM sys.dual;
1409: --
1410: hr_utility.set_location('INS_PRIMARY_BALANCE_FEED', 5);
1411: --
1412: INSERT INTO pay_balance_feeds_f
1413: (balance_feed_id,
1414: effective_start_date,
1415: effective_end_date,
1416: input_value_id,

Line 1513: UPDATE pay_balance_feeds_f

1509: --
1510: IF (p_balance_feed_id is not NULL AND
1511: p_scale is not NULL) THEN
1512: --
1513: UPDATE pay_balance_feeds_f
1514: SET scale = p_scale
1515: WHERE balance_feed_id = p_balance_feed_id;
1516: --
1517: ELSE

Line 1535: UPDATE pay_balance_feeds_f

1531: p_legislation_code is not NULL) THEN
1532: --
1533: v_pay_value := hr_input_values.get_pay_value_name(p_legislation_code);
1534: --
1535: UPDATE pay_balance_feeds_f
1536: SET scale = p_scale
1537: WHERE balance_type_id = p_balance_type_id
1538: AND input_value_id in
1539: (SELECT iv.input_value_id

Line 1565: UPDATE pay_balance_feeds_f

1561: p_legislation_code is not NULL) THEN
1562: --
1563: v_pay_value := hr_input_values.get_pay_value_name(p_legislation_code);
1564: --
1565: UPDATE pay_balance_feeds_f
1566: SET scale = p_scale
1567: WHERE balance_type_id = p_balance_type_id
1568: AND input_value_id in
1569: (SELECT iv.input_value_id

Line 1675: DELETE FROM pay_balance_feeds_f

1671: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1672: AND KEY_VALUE = p_balance_feed_id;
1673: END IF;
1674: --
1675: DELETE FROM pay_balance_feeds_f
1676: WHERE balance_feed_id = p_balance_feed_id;
1677: --
1678: ELSIF (p_delete_mode = 'DELETE' AND
1679: p_session_date is not NULL) THEN

Line 1681: UPDATE pay_balance_feeds_f

1677: --
1678: ELSIF (p_delete_mode = 'DELETE' AND
1679: p_session_date is not NULL) THEN
1680: --
1681: UPDATE pay_balance_feeds_f
1682: SET effective_end_date = p_session_date
1683: WHERE balance_feed_id = p_balance_feed_id
1684: AND effective_start_date <= p_session_date
1685: AND effective_end_date >= p_session_date;

Line 1687: DELETE FROM pay_balance_feeds_f

1683: WHERE balance_feed_id = p_balance_feed_id
1684: AND effective_start_date <= p_session_date
1685: AND effective_end_date >= p_session_date;
1686: --
1687: DELETE FROM pay_balance_feeds_f
1688: WHERE balance_feed_id = p_balance_feed_id
1689: AND effective_start_date > p_session_date;
1690: --
1691: ELSIF (p_delete_mode = 'DELETE_NEXT_CHANGE' AND

Line 1695: UPDATE pay_balance_feeds_f

1691: ELSIF (p_delete_mode = 'DELETE_NEXT_CHANGE' AND
1692: p_effective_end_date is not NULL AND
1693: p_session_date is not NULL) THEN
1694: --
1695: UPDATE pay_balance_feeds_f
1696: SET effective_end_date = p_effective_end_date
1697: WHERE balance_feed_id = p_balance_feed_id
1698: AND effective_start_date <= p_session_date
1699: AND effective_end_date >= p_session_date;

Line 1701: DELETE FROM pay_balance_feeds_f

1697: WHERE balance_feed_id = p_balance_feed_id
1698: AND effective_start_date <= p_session_date
1699: AND effective_end_date >= p_session_date;
1700: --
1701: DELETE FROM pay_balance_feeds_f
1702: WHERE balance_feed_id = p_balance_feed_id
1703: AND effective_start_date > p_session_date;
1704: --
1705: ELSE

Line 1731: FROM pay_balance_feeds_f

1727: DELETE FROM hr_application_ownerships
1728: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1729: AND KEY_VALUE IN
1730: (SELECT balance_feed_id
1731: FROM pay_balance_feeds_f
1732: WHERE input_value_id = p_input_value_id);
1733: END IF;
1734: --
1735: DELETE FROM pay_balance_feeds_f

Line 1735: DELETE FROM pay_balance_feeds_f

1731: FROM pay_balance_feeds_f
1732: WHERE input_value_id = p_input_value_id);
1733: END IF;
1734: --
1735: DELETE FROM pay_balance_feeds_f
1736: WHERE input_value_id = p_input_value_id;
1737: --
1738: ELSIF (p_delete_mode = 'DELETE' AND
1739: p_session_date is not NULL) then

Line 1741: UPDATE pay_balance_feeds_f

1737: --
1738: ELSIF (p_delete_mode = 'DELETE' AND
1739: p_session_date is not NULL) then
1740: --
1741: UPDATE pay_balance_feeds_f
1742: SET effective_end_date = p_session_date
1743: WHERE input_value_id = p_input_value_id
1744: AND effective_start_date <= p_session_date
1745: AND effective_end_date >= p_session_date;

Line 1747: DELETE FROM pay_balance_feeds_f

1743: WHERE input_value_id = p_input_value_id
1744: AND effective_start_date <= p_session_date
1745: AND effective_end_date >= p_session_date;
1746: --
1747: DELETE FROM pay_balance_feeds_f
1748: WHERE input_value_id = p_input_value_id
1749: AND effective_start_date > p_session_date;
1750: --
1751: ELSIF (p_delete_mode = 'DELETE_NEXT_CHANGE' AND

Line 1759: UPDATE pay_balance_feeds_f

1755: hr_utility.trace(to_char(p_effective_end_date));
1756: hr_utility.trace(to_char(p_input_value_id));
1757: hr_utility.trace(to_char(p_session_date));
1758: --
1759: UPDATE pay_balance_feeds_f
1760: SET effective_end_date = p_effective_end_date
1761: WHERE input_value_id = p_input_value_id
1762: AND effective_start_date <= p_session_date
1763: AND effective_end_date >= p_session_date;

Line 1765: DELETE FROM pay_balance_feeds_f

1761: WHERE input_value_id = p_input_value_id
1762: AND effective_start_date <= p_session_date
1763: AND effective_end_date >= p_session_date;
1764: --
1765: DELETE FROM pay_balance_feeds_f
1766: WHERE input_value_id = p_input_value_id
1767: AND effective_start_date > p_session_date;
1768: --
1769: ELSE

Line 1800: FROM pay_balance_feeds_f feed,

1796: DELETE FROM hr_application_ownerships
1797: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1798: AND KEY_VALUE IN
1799: (SELECT feed.balance_feed_id
1800: FROM pay_balance_feeds_f feed,
1801: pay_input_values_f iv,
1802: pay_balance_classifications bc
1803: WHERE iv.element_type_id = p_element_type_id
1804: AND iv.name = 'Pay Value'

Line 1812: DELETE FROM pay_balance_feeds_f

1808: AND feed.balance_type_id
1809: = bc.balance_type_id);
1810: END IF;
1811: --
1812: DELETE FROM pay_balance_feeds_f
1813: WHERE balance_feed_id in
1814: (SELECT feed.balance_feed_id
1815: FROM pay_balance_feeds_f feed,
1816: pay_input_values_f iv,

Line 1815: FROM pay_balance_feeds_f feed,

1811: --
1812: DELETE FROM pay_balance_feeds_f
1813: WHERE balance_feed_id in
1814: (SELECT feed.balance_feed_id
1815: FROM pay_balance_feeds_f feed,
1816: pay_input_values_f iv,
1817: pay_balance_classifications bc
1818: WHERE iv.element_type_id = p_element_type_id
1819: AND iv.name = 'Pay Value'

Line 1829: UPDATE pay_balance_feeds_f

1825: --
1826: ELSIF (p_delete_mode = 'DELETE' AND
1827: p_session_date is not NULL) THEN
1828: --
1829: UPDATE pay_balance_feeds_f
1830: SET effective_end_date = p_session_date
1831: WHERE balance_feed_id in
1832: (SELECT feed.balance_feed_id
1833: FROM pay_balance_feeds_f feed,

Line 1833: FROM pay_balance_feeds_f feed,

1829: UPDATE pay_balance_feeds_f
1830: SET effective_end_date = p_session_date
1831: WHERE balance_feed_id in
1832: (SELECT feed.balance_feed_id
1833: FROM pay_balance_feeds_f feed,
1834: pay_input_values_f iv,
1835: pay_balance_classifications bc
1836: WHERE iv.element_type_id = p_element_type_id
1837: AND iv.name = 'Pay Value'

Line 1846: DELETE FROM pay_balance_feeds_f

1842: = bc.balance_type_id)
1843: AND effective_start_date <= p_session_date
1844: AND effective_end_date >= p_session_date;
1845: --
1846: DELETE FROM pay_balance_feeds_f
1847: WHERE balance_feed_id in
1848: (SELECT feed.balance_feed_id
1849: FROM pay_balance_feeds_f feed,
1850: pay_input_values_f iv,

Line 1849: FROM pay_balance_feeds_f feed,

1845: --
1846: DELETE FROM pay_balance_feeds_f
1847: WHERE balance_feed_id in
1848: (SELECT feed.balance_feed_id
1849: FROM pay_balance_feeds_f feed,
1850: pay_input_values_f iv,
1851: pay_balance_classifications bc
1852: WHERE iv.element_type_id = p_element_type_id
1853: AND iv.name = 'Pay Value'

Line 1865: UPDATE pay_balance_feeds_f

1861: ELSIF (p_delete_mode = 'DELETE_NEXT_CHANGE' AND
1862: p_effective_end_date is not NULL AND
1863: p_session_date is not NULL) THEN
1864: --
1865: UPDATE pay_balance_feeds_f
1866: SET effective_end_date = p_effective_end_date
1867: WHERE balance_feed_id in
1868: (SELECT feed.balance_feed_id
1869: FROM pay_balance_feeds_f feed,

Line 1869: FROM pay_balance_feeds_f feed,

1865: UPDATE pay_balance_feeds_f
1866: SET effective_end_date = p_effective_end_date
1867: WHERE balance_feed_id in
1868: (SELECT feed.balance_feed_id
1869: FROM pay_balance_feeds_f feed,
1870: pay_input_values_f iv,
1871: pay_balance_classifications bc
1872: WHERE iv.element_type_id = p_element_type_id
1873: AND iv.name = 'Pay Value'

Line 1882: DELETE FROM pay_balance_feeds_f

1878: = bc.balance_type_id)
1879: AND effective_start_date <= p_session_date
1880: AND effective_end_date >= p_session_date;
1881: --
1882: DELETE FROM pay_balance_feeds_f
1883: WHERE balance_feed_id in
1884: (SELECT feed.balance_feed_id
1885: FROM pay_balance_feeds_f feed,
1886: pay_input_values_f iv,

Line 1885: FROM pay_balance_feeds_f feed,

1881: --
1882: DELETE FROM pay_balance_feeds_f
1883: WHERE balance_feed_id in
1884: (SELECT feed.balance_feed_id
1885: FROM pay_balance_feeds_f feed,
1886: pay_input_values_f iv,
1887: pay_balance_classifications bc
1888: WHERE iv.element_type_id = p_element_type_id
1889: AND iv.name = 'Pay Value'

Line 1927: FROM pay_balance_feeds_f

1923: DELETE FROM hr_application_ownerships
1924: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1925: AND KEY_VALUE IN
1926: (SELECT balance_feed_id
1927: FROM pay_balance_feeds_f
1928: WHERE balance_type_id = p_balance_type_id
1929: AND input_value_id IN
1930: (SELECT iv.input_value_id
1931: FROM pay_input_values_f iv,

Line 1939: DELETE FROM pay_balance_feeds_f

1935: = p_primary_classification_id
1936: AND iv.name = 'Pay Value'));
1937: END IF;
1938: --
1939: DELETE FROM pay_balance_feeds_f
1940: WHERE balance_type_id = p_balance_type_id
1941: AND input_value_id in
1942: (SELECT iv.input_value_id
1943: FROM pay_input_values_f iv,

Line 1980: FROM pay_balance_feeds_f

1976: DELETE FROM hr_application_ownerships
1977: WHERE KEY_NAME = 'BALANCE_FEED_ID'
1978: AND KEY_VALUE IN
1979: (SELECT balance_feed_id
1980: FROM pay_balance_feeds_f
1981: WHERE balance_type_id = p_balance_type_id
1982: AND input_value_id IN
1983: (SELECT iv.input_value_id
1984: FROM pay_input_values_f iv,

Line 1996: DELETE FROM pay_balance_feeds_f

1992: AND iv.effective_start_date
1993: <= scr.effective_end_date));
1994: END IF;
1995: --
1996: DELETE FROM pay_balance_feeds_f
1997: WHERE balance_type_id = p_balance_type_id
1998: AND input_value_id in
1999: (SELECT iv.input_value_id
2000: FROM pay_input_values_f iv,

Line 2081: FROM pay_balance_feeds_f

2077: DELETE FROM hr_application_ownerships
2078: WHERE KEY_NAME = 'BALANCE_FEED_ID'
2079: AND KEY_VALUE IN
2080: (SELECT balance_feed_id
2081: FROM pay_balance_feeds_f
2082: WHERE balance_type_id = p_balance_type_id);
2083: END IF;
2084: --
2085: DELETE FROM pay_balance_feeds_f

Line 2085: DELETE FROM pay_balance_feeds_f

2081: FROM pay_balance_feeds_f
2082: WHERE balance_type_id = p_balance_type_id);
2083: END IF;
2084: --
2085: DELETE FROM pay_balance_feeds_f
2086: WHERE balance_type_id = p_balance_type_id;
2087: --
2088: ELSE
2089: --

Line 2182: from pay_balance_feeds_f bf

2178: CURSOR get_dup_balance_feeds(p_input_value_id number,
2179: p_balance_type_id number) is
2180: select bf.effective_start_date start_date,
2181: bf.effective_end_date end_date
2182: from pay_balance_feeds_f bf
2183: where p_input_value_id = bf.input_value_id
2184: and p_balance_feed_id <> bf.balance_feed_id
2185: and p_balance_type_id = bf.balance_type_id
2186: order by bf.effective_start_date;