DBA Data[Home] [Help]

APPS.PAY_PAYWSLEE_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 239: , pay_element_links_f pil

235: , nvl (b.default_value, TYPE.default_value) hot_default_value
236: FROM (
237: SELECT *
238: FROM pay_input_values_f piv
239: , pay_element_links_f pil
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)

Line 788: , pay_element_links_f pil

784: , nvl (b.default_value, TYPE.default_value) hot_default_value
785: FROM (
786: SELECT *
787: FROM pay_input_values_f piv
788: , pay_element_links_f pil
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)