DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on PAY_INPUT_VALUES_F

Line 1975: FROM pay_input_values_f piv

1971: p_effective_date pay_element_types_f.effective_start_date%TYPE
1972: )
1973: IS
1974: SELECT piv.NAME
1975: FROM pay_input_values_f piv
1976: WHERE piv.element_type_id = p_element_type_id
1977: AND p_effective_date BETWEEN piv.effective_start_date
1978: AND piv.effective_end_date
1979: ORDER BY piv.display_sequence, piv.NAME;

Line 2110: FROM pay_input_values_f piv,

2106: p_element_type_id pay_element_types_f.element_type_id%TYPE
2107: )
2108: IS
2109: SELECT DISTINCT piv.NAME
2110: FROM pay_input_values_f piv,
2111: pay_accrual_plans pap,
2112: pay_net_calculation_rules pncr
2113: WHERE piv.element_type_id = p_element_type_id
2114: AND p_effective_date BETWEEN piv.effective_start_date