eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_LINKS_F

Line 5982: ,pay_element_links_f pel

5978: ,c_effective_date in date
5979: ,c_element_type_id in number ) Is
5980: Select pee.element_entry_id
5981: from pay_element_entries_f pee
5982: ,pay_element_links_f pel
5983: where pee.assignment_id = c_assignment_id
5984: and pel.element_link_id = pee.element_link_id
5985: and pel.element_type_id = c_element_type_id
5986: and c_effective_date between pee.effective_start_date

Line 6315: from pay_element_links_f pel

6311: p_assignment_id IN NUMBER
6312: ,p_element_type_id IN NUMBER
6313: ,p_date IN DATE )IS
6314: select 'Y'
6315: from pay_element_links_f pel
6316: ,pay_element_entries_f pee
6317: ,pay_element_types_f pet
6318: where pet.element_type_id = pel.element_type_id
6319: and pel.element_link_id = pee.element_link_id

Line 16786: FROM pay_element_links_f pel

16782: AND petei.eei_information_category ='PQP_UK_ELEMENT_ATTRIBUTION';
16783:
16784: CURSOR c_element_entry(p_element_type_id IN NUMBER) IS
16785: SELECT pee.element_entry_id
16786: FROM pay_element_links_f pel
16787: ,pay_element_entries_f pee
16788: where pel.element_type_id = p_element_type_id
16789: and p_effective_date between pel.effective_start_date
16790: and pel.effective_end_date

Line 17316: ,pay_element_links_f pel

17312: )
17313: IS
17314: SELECT 'X'
17315: FROM pay_element_entries_f pee
17316: ,pay_element_links_f pel
17317: WHERE pee.assignment_id = c_assignment_id
17318: AND pee.entry_type = 'E'
17319: AND pee.element_link_id = pel.element_link_id
17320: AND c_effective_date BETWEEN pee.effective_start_date