APPS.PAY_PAYWSLEE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 35: from pay_element_types_f ELEMENT

31: and input_value_tl.input_value_id = input_value.input_value_id
32: and userenv('LANG') = input_value_tl.language
33: and input_value.effective_start_date =
34: (select min (element.effective_start_date)
35: from pay_element_types_f ELEMENT
36: where element.element_type_id = p_element_type_id)
37: --
38: order by input_value.display_sequence,
39: input_value_tl.name;

Line 157: from pay_element_types_f ELEMENT

153: and input_value_tl.input_value_id = input_value.input_value_id
154: and userenv('LANG') = input_value_tl.language
155: and input_value.effective_start_date =
156: (select min (element.effective_start_date)
157: from pay_element_types_f ELEMENT
158: where element.element_type_id = p_element_type_id)
159: order by input_value.display_sequence,
160: input_value_tl.name;
161: --