DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 218: pay_element_entries_f pee,

214: pee.entry_information24 court_order_origin,
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

Line 255: from pay_element_entries_f pee

251: IS
252: --
253: Cursor csr_get_court_order_start_date(p_element_entry_id IN NUMBER) IS
254: select min(effective_start_date)
255: from pay_element_entries_f pee
256: where pee.element_entry_id = p_element_entry_id;
257: --
258: l_court_order_start_date DATE;
259: --

Line 744: pay_element_entries_f pee,

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

Line 2186: pay_element_entries_f pee,

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