DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 224: pay_element_entries_f pee,

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

Line 261: from pay_element_entries_f pee

257: IS
258: --
259: Cursor csr_get_court_order_start_date(p_element_entry_id IN NUMBER) IS
260: select min(effective_start_date)
261: from pay_element_entries_f pee
262: where pee.element_entry_id = p_element_entry_id;
263: --
264: l_court_order_start_date DATE;
265: --

Line 750: pay_element_entries_f pee,

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

Line 2209: pay_element_entries_f pee,

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