DBA Data[Home] [Help]

APPS.BEN_ICD_ELEMENT_ENTRY_PKG dependencies on PAY_INPUT_VALUES_F

Line 161: pay_input_values_f

157: ) is
158:
159: cursor c_input_values is
160: select * from
161: pay_input_values_f
162: where element_type_id = (select element_type_id from pay_element_entries_f where
163: element_entry_id = p_element_entry_id and p_effective_date between effective_start_date and effective_end_date)
164: and p_effective_date between effective_start_date and effective_end_date
165: order by input_value_id asc;

Line 553: pay_input_values_f

549: ) is
550:
551: cursor c_input_values is
552: select * from
553: pay_input_values_f
554: where element_type_id = (select element_type_id from pay_element_links_f where
555: element_link_id = p_element_link_id and p_effective_date between effective_start_date and effective_end_date)
556: and p_effective_date between effective_start_date and effective_end_date
557: order by input_value_id asc;