DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 3126: FROM pay_element_entries_f pee, pay_element_links_f pel

3122: CURSOR csr_get_ni_ele_info (c_effective_date DATE)
3123: IS
3124: SELECT pee.element_entry_id, pee.effective_start_date
3125: ,pee.effective_end_date
3126: FROM pay_element_entries_f pee, pay_element_links_f pel
3127: WHERE pee.assignment_id = p_assignment_id
3128: AND pee.entry_type = 'E'
3129: AND pee.element_link_id = pel.element_link_id
3130: AND c_effective_date BETWEEN pee.effective_start_date

Line 4774: FROM pay_element_entries_f pee, pay_element_links_f pel

4770: ,c_effective_end_date DATE)
4771: IS
4772: SELECT pee.element_entry_id, pee.effective_start_date
4773: ,pee.effective_end_date, pel.element_type_id
4774: FROM pay_element_entries_f pee, pay_element_links_f pel
4775: WHERE pee.assignment_id = c_assignment_id
4776: AND pee.entry_type = 'E'
4777: AND pee.element_link_id = pel.element_link_id
4778: AND (