APPS.HR_ELEMENT_LINKS dependencies on PAY_INPUT_VALUES_F

Line 677: pay_input_values_f TYPE

673: --
674: cursor csr_link_defaults is
675: select 1
676: from pay_link_input_values_f LINK,
677: pay_input_values_f TYPE
678: where link.element_link_id = p_element_link_id
679: and link.input_value_id = type.input_value_id
680: and type.mandatory_flag = 'Y'
681: and p_standard_link_flag = 'Y'

Line 813: from pay_input_values_f_tl iv_tl,

809: set liv.costed_flag = 'Y'
810: where p_element_link_id = liv.element_link_id
811: and liv.input_value_id =
812: (select iv.input_value_id
813: from pay_input_values_f_tl iv_tl,
814: pay_input_values_f iv
815: where liv.input_value_id = iv.input_value_id
816: and iv.input_value_id = iv_tl.input_value_id
817: and iv_tl.name = p_pay_value_name

Line 814: pay_input_values_f iv

810: where p_element_link_id = liv.element_link_id
811: and liv.input_value_id =
812: (select iv.input_value_id
813: from pay_input_values_f_tl iv_tl,
814: pay_input_values_f iv
815: where liv.input_value_id = iv.input_value_id
816: and iv.input_value_id = iv_tl.input_value_id
817: and iv_tl.name = p_pay_value_name
818: and userenv('LANG') = iv_tl.language

Line 1105: from pay_input_values_f_tl iv_tl,

1101: iv.default_value default_valuE,
1102: iv.min_value min_valuE,
1103: iv.max_value max_valuE,
1104: iv.hot_default_flag hot_default_flag
1105: from pay_input_values_f_tl iv_tl,
1106: pay_input_values_f iv
1107: where iv.input_value_id = iv_tl.input_value_id
1108: and iv.input_value_id = p_input_value_id
1109: and userenv('LANG') = iv_tl.language

Line 1106: pay_input_values_f iv

1102: iv.min_value min_valuE,
1103: iv.max_value max_valuE,
1104: iv.hot_default_flag hot_default_flag
1105: from pay_input_values_f_tl iv_tl,
1106: pay_input_values_f iv
1107: where iv.input_value_id = iv_tl.input_value_id
1108: and iv.input_value_id = p_input_value_id
1109: and userenv('LANG') = iv_tl.language
1110: and iv.effective_start_date <= p_validation_end_date