DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 219: pay_element_links_f pel,

215: name,
216: peev.screen_entry_value
217: from pay_element_entry_values_f peev,
218: pay_element_entries_f pee,
219: pay_element_links_f pel,
220: pay_input_values_f piv
221: where pel.element_type_id = p_element_type_id
222: and piv.element_type_id = p_element_type_id
223: and piv.element_type_id = pel.element_type_id

Line 745: pay_element_links_f pel,

741: cursor csr_get_provisional_date(p_prev_case_num IN VARCHAR2) is
742: SELECT pee.effective_start_date,pee.entry_information24
743: from pay_element_entry_values_f peev,
744: pay_element_entries_f pee,
745: pay_element_links_f pel,
746: pay_input_values_f piv
747: where pel.element_type_id = l_element_type_id
748: and piv.element_type_id = l_element_type_id
749: and piv.element_type_id = pel.element_type_id

Line 2187: pay_element_links_f pel,

2183: Cursor csr_attach IS
2184: SELECT 'Y'
2185: from pay_element_entry_values_f peev,
2186: pay_element_entries_f pee,
2187: pay_element_links_f pel,
2188: pay_input_values_f piv,
2189: pay_element_types_f pet,
2190: fnd_sessions ses
2191: where pet.element_name = 'Wage Garnishments'