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_INPUT_VALUES_F

Line 32: PAY_INPUT_VALUES_F

28: Description : This package holds procedures and functions related to the
29: following tables :
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

Line 226: pay_input_values_f iv

222: iv.created_by a_created_by
223: FROM pay_balance_types bt,
224: pay_balance_classifications bc,
225: pay_element_types_f et,
226: pay_input_values_f iv
227: WHERE iv.input_value_id = p_input_value_id
228: AND et.element_type_id = iv.element_type_id
229: AND et.effective_start_date <= p_session_date
230: AND et.effective_end_date >= p_session_date

Line 249: pay_input_values_f iv

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
250: WHERE iv.input_value_id = p_input_value_id
251: AND et.element_type_id = iv.element_type_id
252: AND et.effective_start_date <= p_session_date
253: AND et.effective_end_date >= p_session_date

Line 286: pay_input_values_f iv

282: iv.created_by a_created_by
283: FROM pay_balance_types bt,
284: pay_balance_classifications bc,
285: pay_element_types_f et,
286: pay_input_values_f iv
287: WHERE iv.input_value_id = p_input_value_id
288: AND et.element_type_id = iv.element_type_id
289: AND et.effective_start_date <= p_session_date
290: AND et.effective_end_date >= p_session_date

Line 309: pay_input_values_f iv

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
310: WHERE iv.input_value_id = p_input_value_id
311: AND et.element_type_id = iv.element_type_id
312: AND et.effective_start_date <= p_session_date
313: AND et.effective_end_date >= p_session_date

Line 347: pay_input_values_f iv

343: FROM pay_balance_types bt,
344: pay_balance_classifications bc,
345: pay_element_types_f et,
346: pay_sub_classification_rules_f scr,
347: pay_input_values_f iv
348: WHERE iv.input_value_id = p_input_value_id
349: AND scr.element_type_id = iv.element_type_id
350: AND iv.effective_start_date <= scr.effective_end_date
351: AND iv.effective_end_date >= scr.effective_start_date

Line 374: pay_input_values_f iv

370: pay_balance_types bt,
371: pay_balance_classifications bc,
372: pay_element_types_f et,
373: pay_sub_classification_rules_f scr,
374: pay_input_values_f iv
375: WHERE iv.input_value_id = p_input_value_id
376: AND scr.element_type_id = iv.element_type_id
377: AND iv.effective_end_date >= scr.effective_start_date
378: AND iv.effective_start_date <= scr.effective_end_date

Line 403: pay_input_values_f iv

399: et.element_type_id,
400: bt.balance_type_id
401: FROM pay_balance_types bt,
402: pay_element_types_f et,
403: pay_input_values_f iv
404: WHERE iv.input_value_id = p_input_value_id
405: AND et.element_type_id = iv.element_type_id
406: AND et.effective_start_date <= p_session_date
407: AND et.effective_end_date >= p_session_date

Line 419: pay_input_values_f iv

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
421: AND et.element_type_id = iv.element_type_id
422: AND et.effective_start_date <= p_session_date
423: AND et.effective_end_date >= p_session_date

Line 443: pay_input_values_f_tl iv_tl,

439: bt.balance_type_id
440: FROM pay_balance_types bt,
441: pay_balance_classifications bc,
442: pay_element_types_f et,
443: pay_input_values_f_tl iv_tl,
444: pay_input_values_f iv,
445: pay_sub_classification_rules_f scr
446: WHERE iv_tl.input_value_id = iv.input_value_id
447: and userenv('LANG') = iv_tl.language

Line 444: pay_input_values_f iv,

440: FROM pay_balance_types bt,
441: pay_balance_classifications bc,
442: pay_element_types_f et,
443: pay_input_values_f_tl iv_tl,
444: pay_input_values_f iv,
445: pay_sub_classification_rules_f scr
446: WHERE iv_tl.input_value_id = iv.input_value_id
447: and userenv('LANG') = iv_tl.language
448: AND scr.sub_classification_rule_id

Line 475: pay_input_values_f_tl iv_tl,

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,
476: pay_input_values_f iv,
477: pay_sub_classification_rules_f scr
478: WHERE iv_tl.input_value_id = iv.input_value_id
479: and userenv('LANG') = iv_tl.language

Line 476: pay_input_values_f iv,

472: pay_balance_types bt,
473: pay_balance_classifications bc,
474: pay_element_types_f et,
475: pay_input_values_f_tl iv_tl,
476: pay_input_values_f iv,
477: pay_sub_classification_rules_f scr
478: WHERE iv_tl.input_value_id = iv.input_value_id
479: and userenv('LANG') = iv_tl.language
480: and scr.sub_classification_rule_id

Line 514: pay_input_values_f_tl iv_tl,

510: iv.business_group_id a_business_group_id,
511: iv.legislation_code a_legislation_code,
512: iv.legislation_subgroup a_legislation_subgroup
513: FROM pay_element_types_f et,
514: pay_input_values_f_tl iv_tl,
515: pay_input_values_f iv,
516: pay_sub_classification_rules_f scr
517: WHERE iv_tl.input_value_id = iv.input_value_id
518: and userenv('LANG') = iv_tl.language

Line 515: pay_input_values_f iv,

511: iv.legislation_code a_legislation_code,
512: iv.legislation_subgroup a_legislation_subgroup
513: FROM pay_element_types_f et,
514: pay_input_values_f_tl iv_tl,
515: pay_input_values_f iv,
516: pay_sub_classification_rules_f scr
517: WHERE iv_tl.input_value_id = iv.input_value_id
518: and userenv('LANG') = iv_tl.language
519: and scr.sub_classification_rule_id

Line 562: pay_input_values_f_tl iv_tl,

558: SELECT iv.input_value_id,
559: et.element_type_id,
560: bt.balance_type_id
561: FROM pay_balance_types bt,
562: pay_input_values_f_tl iv_tl,
563: pay_input_values_f iv,
564: pay_element_types_f et
565: WHERE iv_tl.input_value_id = iv.input_value_id
566: and userenv('LANG') = iv_tl.language

Line 563: pay_input_values_f iv,

559: et.element_type_id,
560: bt.balance_type_id
561: FROM pay_balance_types bt,
562: pay_input_values_f_tl iv_tl,
563: pay_input_values_f iv,
564: pay_element_types_f et
565: WHERE iv_tl.input_value_id = iv.input_value_id
566: and userenv('LANG') = iv_tl.language
567: and et.classification_id = p_primary_classification_id

Line 587: pay_input_values_f_tl iv_tl,

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
590: WHERE iv_tl.input_value_id = iv.input_value_id
591: and userenv('LANG') = iv_tl.language

Line 588: pay_input_values_f iv,

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
590: WHERE iv_tl.input_value_id = iv.input_value_id
591: and userenv('LANG') = iv_tl.language
592: and et.classification_id = p_primary_classification_id

Line 612: FROM pay_input_values_f iv1

608: AND feed.input_value_id = iv.input_value_id
609: AND feed.balance_type_id = bt.balance_type_id
610: AND feed.effective_start_date <=
611: (SELECT max(iv.effective_end_date)
612: FROM pay_input_values_f iv1
613: WHERE iv1.input_value_id = iv.input_value_id
614: GROUP BY iv1.input_value_id)
615: AND feed.effective_end_date >=
616: (SELECT min(iv2.effective_start_date)

Line 617: FROM pay_input_values_f iv2

613: WHERE iv1.input_value_id = iv.input_value_id
614: GROUP BY iv1.input_value_id)
615: AND feed.effective_end_date >=
616: (SELECT min(iv2.effective_start_date)
617: FROM pay_input_values_f iv2
618: WHERE iv2.input_value_id = iv.input_value_id
619: GROUP BY iv2.input_value_id);
620: --
621: CURSOR cur_iv_primary_bal_class IS

Line 631: pay_input_values_f_tl iv_tl,

627: iv.business_group_id a_business_group_id,
628: iv.legislation_code a_legislation_code,
629: iv.legislation_subgroup a_legislation_subgroup
630: FROM pay_balance_types bt,
631: pay_input_values_f_tl iv_tl,
632: pay_input_values_f iv,
633: pay_element_types_f et
634: WHERE iv_tl.input_value_id = iv.input_value_id
635: and userenv('LANG') = iv_tl.language

Line 632: pay_input_values_f iv,

628: iv.legislation_code a_legislation_code,
629: iv.legislation_subgroup a_legislation_subgroup
630: FROM pay_balance_types bt,
631: pay_input_values_f_tl iv_tl,
632: pay_input_values_f iv,
633: pay_element_types_f et
634: WHERE iv_tl.input_value_id = iv.input_value_id
635: and userenv('LANG') = iv_tl.language
636: and et.classification_id = p_primary_classification_id

Line 660: pay_input_values_f_tl iv_tl,

656: scr.sub_classification_rule_id,
657: bt.balance_type_id
658: FROM pay_balance_types bt,
659: pay_element_types_f et,
660: pay_input_values_f_tl iv_tl,
661: pay_input_values_f iv,
662: pay_sub_classification_rules_f scr
663: WHERE iv_tl.input_value_id = iv.input_value_id
664: and userenv('LANG') = iv_tl.language

Line 661: pay_input_values_f iv,

657: bt.balance_type_id
658: FROM pay_balance_types bt,
659: pay_element_types_f et,
660: pay_input_values_f_tl iv_tl,
661: pay_input_values_f iv,
662: pay_sub_classification_rules_f scr
663: WHERE iv_tl.input_value_id = iv.input_value_id
664: and userenv('LANG') = iv_tl.language
665: and scr.classification_id = p_sub_classification_id

Line 687: pay_input_values_f_tl iv_tl,

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,
689: pay_sub_classification_rules_f scr
690: WHERE iv_tl.input_value_id = iv.input_value_id
691: and userenv('LANG') = iv_tl.language

Line 688: pay_input_values_f iv,

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,
689: pay_sub_classification_rules_f scr
690: WHERE iv_tl.input_value_id = iv.input_value_id
691: and userenv('LANG') = iv_tl.language
692: and scr.classification_id = p_sub_classification_id

Line 725: pay_input_values_f_tl iv_tl,

721: iv.legislation_code a_legislation_code,
722: iv.legislation_subgroup a_legislation_subgroup
723: FROM pay_balance_types bt,
724: pay_element_types_f et,
725: pay_input_values_f_tl iv_tl,
726: pay_input_values_f iv,
727: pay_sub_classification_rules_f scr
728: WHERE iv_tl.input_value_id = iv.input_value_id
729: and userenv('LANG') = iv_tl.language

Line 726: pay_input_values_f iv,

722: iv.legislation_subgroup a_legislation_subgroup
723: FROM pay_balance_types bt,
724: pay_element_types_f et,
725: pay_input_values_f_tl iv_tl,
726: pay_input_values_f iv,
727: pay_sub_classification_rules_f scr
728: WHERE iv_tl.input_value_id = iv.input_value_id
729: and userenv('LANG') = iv_tl.language
730: and scr.classification_id = p_sub_classification_id

Line 1063: FROM pay_input_values_f iv,

1059: iv.last_updated_by,
1060: iv.last_update_login,
1061: iv.created_by,
1062: trunc(sysdate)
1063: FROM pay_input_values_f iv,
1064: pay_element_types_f et,
1065: pay_balance_types bt
1066: WHERE iv.input_value_id = p_input_value_id
1067: AND et.element_type_id = iv.element_type_id

Line 1441: FROM pay_input_values_f iv,

1437: bt.last_updated_by,
1438: bt.last_update_login,
1439: bt.created_by,
1440: trunc(sysdate)
1441: FROM pay_input_values_f iv,
1442: pay_element_types_f et,
1443: pay_balance_types bt
1444: WHERE iv.input_value_id = p_input_value_id
1445: AND et.element_type_id = iv.element_type_id

Line 1540: FROM pay_input_values_f iv,

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
1540: FROM pay_input_values_f iv,
1541: pay_element_types_f et
1542: WHERE iv.element_type_id = et.element_type_id
1543: and et.classification_id
1544: = p_primary_classification_id

Line 1570: FROM pay_input_values_f iv,

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
1570: FROM pay_input_values_f iv,
1571: pay_sub_classification_rules_f scr
1572: WHERE iv.element_type_id = scr.element_type_id
1573: and scr.classification_id
1574: = p_sub_classification_id

Line 1801: pay_input_values_f iv,

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'
1805: AND feed.input_value_id = iv.input_value_id

Line 1816: pay_input_values_f iv,

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'
1820: AND feed.input_value_id = iv.input_value_id

Line 1834: pay_input_values_f iv,

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'
1838: AND feed.input_value_id = iv.input_value_id

Line 1850: pay_input_values_f iv,

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'
1854: AND feed.input_value_id = iv.input_value_id

Line 1870: pay_input_values_f iv,

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'
1874: AND feed.input_value_id = iv.input_value_id

Line 1886: pay_input_values_f iv,

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'
1890: AND feed.input_value_id = iv.input_value_id

Line 1931: FROM pay_input_values_f iv,

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,
1932: pay_element_types_f et
1933: WHERE iv.element_type_id = et.element_type_id
1934: and et.classification_id
1935: = p_primary_classification_id

Line 1943: FROM pay_input_values_f iv,

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,
1944: pay_element_types_f et
1945: WHERE iv.element_type_id = et.element_type_id
1946: and et.classification_id
1947: = p_primary_classification_id

Line 1984: FROM pay_input_values_f iv,

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,
1985: pay_sub_classification_rules_f scr
1986: WHERE iv.element_type_id = scr.element_type_id
1987: and scr.classification_id
1988: = p_sub_classification_id

Line 2000: FROM pay_input_values_f iv,

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,
2001: pay_sub_classification_rules_f scr
2002: WHERE iv.element_type_id = scr.element_type_id
2003: and scr.classification_id
2004: = p_sub_classification_id

Line 2215: from pay_input_values_f iv

2211: if l_greatest_date is null then
2212: --
2213: select max(iv.effective_end_date)
2214: into l_greatest_date
2215: from pay_input_values_f iv
2216: where p_input_value_id = iv.input_value_id;
2217: --
2218: end if;
2219: --