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

Line 244: from pay_element_types_f ELEMENT

240: WHERE pil.element_type_id = piv.element_type_id
241: AND pil.element_link_id = p_element_link_id
242: and piv.effective_start_date =
243: (select min (element.effective_start_date)
244: from pay_element_types_f ELEMENT
245: where element.element_type_id = piv.element_type_id)
246: ) TYPE
247: ,
248: (

Line 793: from pay_element_types_f ELEMENT

789: WHERE pil.element_type_id = piv.element_type_id
790: AND pil.element_link_id = p_element_link_id
791: and piv.effective_start_date =
792: (select min (element.effective_start_date)
793: from pay_element_types_f ELEMENT
794: where element.element_type_id = piv.element_type_id)
795: ) TYPE
796: ,
797: (