APPS.HR_BALANCES dependencies on PAY_INPUT_VALUES_F_TL

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