APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PAY_ELEMENT_LINKS_F

Line 1974: FROM pay_element_entries_f pee, pay_element_links_f pel

1970: CURSOR csr_get_ele_ent_details(c_element_type_id NUMBER)
1971: IS
1972: SELECT pee.element_entry_id, pee.effective_start_date
1973: ,pee.effective_end_date, pel.element_type_id
1974: FROM pay_element_entries_f pee, pay_element_links_f pel
1975: WHERE pee.assignment_id = p_assignment_id
1976: AND pee.entry_type = 'E'
1977: AND pee.element_link_id = pel.element_link_id
1978: AND p_effective_date BETWEEN pee.effective_start_date

Line 3268: FROM pay_element_entries_f pee, pay_element_links_f pel

3264: )
3265: IS
3266: SELECT pee.element_entry_id, pee.effective_start_date
3267: ,pee.effective_end_date, pel.element_type_id
3268: FROM pay_element_entries_f pee, pay_element_links_f pel
3269: WHERE pee.assignment_id = p_assignment_id
3270: AND pee.entry_type = 'E'
3271: AND pee.element_link_id = pel.element_link_id
3272: AND (

Line 3298: FROM pay_element_entries_f pee, pay_element_links_f pel

3294: )
3295: IS
3296: SELECT pee.element_entry_id, pee.effective_start_date
3297: ,pee.effective_end_date
3298: FROM pay_element_entries_f pee, pay_element_links_f pel
3299: WHERE pee.assignment_id = p_assignment_id
3300: AND pee.entry_type = 'E'
3301: AND pee.element_link_id = pel.element_link_id
3302: AND (

Line 5093: FROM pay_element_entries_f pee, pay_element_links_f pel

5089: CURSOR csr_get_ele_ent_info(c_element_entry_id NUMBER)
5090: IS
5091: SELECT pel.element_type_id, pee.effective_start_date
5092: ,pee.effective_end_date, pee.element_entry_id
5093: FROM pay_element_entries_f pee, pay_element_links_f pel
5094: WHERE pee.element_entry_id = c_element_entry_id
5095: AND g_effective_date BETWEEN pee.effective_start_date
5096: AND pee.effective_end_date
5097: AND pel.element_link_id = pee.element_link_id