APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_NI_ELEMENT_ENTRIES_V

Line 62: category pay_ni_element_entries_v.category%TYPE,

58: g_ele_entry_details t_ele_entry_details;
59: g_pen_ele_details t_ele_entry_details;
60:
61: TYPE r_ni_ele_details IS RECORD (
62: category pay_ni_element_entries_v.category%TYPE,
63: user_table_id NUMBER,
64: user_row_id NUMBER);
65:
66: TYPE t_ni_ele_details IS TABLE OF r_ni_ele_details

Line 347: FROM pay_ni_element_entries_v

343: c_category VARCHAR2
344: )
345: IS
346: SELECT MIN (effective_start_date)
347: FROM pay_ni_element_entries_v
348: WHERE assignment_id = c_assignment_id
349: AND category = c_category;
350:
351: -- Cursor to get user_table_id

Line 498: -- FROM pay_ni_element_entries_v

494: -- c_effective_date DATE
495: -- )
496: -- IS
497: -- SELECT category
498: -- FROM pay_ni_element_entries_v
499: -- WHERE assignment_id = c_assignment_id
500: -- AND ( c_effective_date BETWEEN effective_start_date
501: -- AND effective_end_date
502: -- OR c_effective_date > effective_start_date