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_SUB_CLASSIFICATION_RULES_F

Line 33: PAY_SUB_CLASSIFICATION_RULES_F

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
37: PAY_DEFINED_BALANCES

Line 346: pay_sub_classification_rules_f scr,

342: iv.created_by a_created_by
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

Line 373: pay_sub_classification_rules_f scr,

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,
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

Line 445: pay_sub_classification_rules_f scr

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
449: = p_sub_classification_rule_id

Line 477: pay_sub_classification_rules_f scr

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
481: = p_sub_classification_rule_id

Line 516: pay_sub_classification_rules_f scr

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
520: = p_sub_classification_rule_id

Line 543: pay_sub_classification_rules_f scr

539: bc.last_update_login a_last_update_login,
540: bc.created_by a_created_by
541: FROM pay_balance_types bt,
542: pay_balance_classifications bc,
543: pay_sub_classification_rules_f scr
544: WHERE scr.sub_classification_rule_id
545: = p_sub_classification_rule_id
546: AND bc.classification_id = scr.classification_id
547: AND bt.balance_type_id = bc.balance_type_id

Line 662: pay_sub_classification_rules_f scr

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
666: AND iv.element_type_id = scr.element_type_id

Line 689: pay_sub_classification_rules_f scr

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
693: AND iv.element_type_id = scr.element_type_id

Line 727: pay_sub_classification_rules_f scr

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
731: AND iv.element_type_id = scr.element_type_id

Line 1571: pay_sub_classification_rules_f scr

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
1575: AND iv.name = 'Pay Value'

Line 1985: pay_sub_classification_rules_f scr

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
1989: AND iv.name = 'Pay Value'

Line 2001: pay_sub_classification_rules_f scr

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
2005: AND iv.name = 'Pay Value'

Line 2118: from pay_sub_classification_rules_f subcr

2114: CURSOR get_dup_class_rules(p_element_type_id number,
2115: p_classification_id number) is
2116: select subcr.effective_start_date start_date,
2117: subcr.effective_end_date end_date
2118: from pay_sub_classification_rules_f subcr
2119: where p_element_type_id = subcr.element_type_id
2120: and subcr.sub_classification_rule_id <> p_sub_class_rule_id
2121: and p_classification_id = subcr.classification_id
2122: order by subcr.effective_start_date;