DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 225: pay_element_links_f pel,

221: name,
222: peev.screen_entry_value
223: from pay_element_entry_values_f peev,
224: pay_element_entries_f pee,
225: pay_element_links_f pel,
226: pay_input_values_f piv
227: where pel.element_type_id = p_element_type_id
228: and piv.element_type_id = p_element_type_id
229: and piv.element_type_id = pel.element_type_id

Line 751: pay_element_links_f pel,

747: cursor csr_get_provisional_date(p_prev_case_num IN VARCHAR2) is
748: SELECT pee.effective_start_date,pee.entry_information24
749: from pay_element_entry_values_f peev,
750: pay_element_entries_f pee,
751: pay_element_links_f pel,
752: pay_input_values_f piv
753: where pel.element_type_id = l_element_type_id
754: and piv.element_type_id = l_element_type_id
755: and piv.element_type_id = pel.element_type_id

Line 2210: pay_element_links_f pel,

2206: Cursor csr_attach IS
2207: SELECT 'Y'
2208: from pay_element_entry_values_f peev,
2209: pay_element_entries_f pee,
2210: pay_element_links_f pel,
2211: pay_input_values_f piv,
2212: pay_element_types_f pet,
2213: fnd_sessions ses
2214: where pet.element_name = 'Wage Garnishments'