APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PAY_ELEMENT_LINKS_F

Line 1992: FROM pay_element_entries_f pee, pay_element_links_f pel

1988: CURSOR csr_get_ele_ent_details(c_element_type_id NUMBER)
1989: IS
1990: SELECT pee.element_entry_id, pee.effective_start_date
1991: ,pee.effective_end_date, pel.element_type_id
1992: FROM pay_element_entries_f pee, pay_element_links_f pel
1993: WHERE pee.assignment_id = p_assignment_id
1994: AND pee.entry_type = 'E'
1995: AND pee.element_link_id = pel.element_link_id
1996: AND p_effective_date BETWEEN pee.effective_start_date

Line 3286: FROM pay_element_entries_f pee, pay_element_links_f pel

3282: )
3283: IS
3284: SELECT pee.element_entry_id, pee.effective_start_date
3285: ,pee.effective_end_date, pel.element_type_id
3286: FROM pay_element_entries_f pee, pay_element_links_f pel
3287: WHERE pee.assignment_id = p_assignment_id
3288: AND pee.entry_type = 'E'
3289: AND pee.element_link_id = pel.element_link_id
3290: AND (

Line 3316: FROM pay_element_entries_f pee, pay_element_links_f pel

3312: )
3313: IS
3314: SELECT pee.element_entry_id, pee.effective_start_date
3315: ,pee.effective_end_date
3316: FROM pay_element_entries_f pee, pay_element_links_f pel
3317: WHERE pee.assignment_id = p_assignment_id
3318: AND pee.entry_type = 'E'
3319: AND pee.element_link_id = pel.element_link_id
3320: AND (

Line 5147: FROM pay_element_entries_f pee, pay_element_links_f pel

5143: CURSOR csr_get_ele_ent_info(c_element_entry_id NUMBER)
5144: IS
5145: SELECT pel.element_type_id, pee.effective_start_date
5146: ,pee.effective_end_date, pee.element_entry_id
5147: FROM pay_element_entries_f pee, pay_element_links_f pel
5148: WHERE pee.element_entry_id = c_element_entry_id
5149: AND g_effective_date BETWEEN pee.effective_start_date
5150: AND pee.effective_end_date
5151: AND pel.element_link_id = pee.element_link_id