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_AD_EE dependencies on PAY_ELEMENT_TYPES_F

Line 142: pay_element_types_f pet,

138: SELECT count(asg.assignment_id)
139: INTO l_asg_count
140: FROM pay_element_links_f pel,
141: pay_element_entries_f pee,
142: pay_element_types_f pet,
143: per_all_assignments_f asg,
144: pay_element_type_extra_info pete,
145: pay_element_entry_values_f peev,
146: pay_input_values_f piv

Line 235: pay_element_types_f pet,

231: pel.effective_end_date link_end_date,
232: pee.effective_start_date
233: FROM pay_element_links_f pel,
234: pay_element_entries_f pee,
235: pay_element_types_f pet,
236: pay_element_type_extra_info pete
237: WHERE pet.element_type_id = pel.element_type_id
238: AND pel.element_link_id = pee.element_link_id
239: AND pet.element_type_id = pete.element_type_id

Line 260: pay_element_types_f pet,

256: CURSOR chk_cur IS
257: SELECT 'x'
258: FROM pay_element_links_f pel,
259: pay_element_entries_f pee,
260: pay_element_types_f pet,
261: pay_element_type_extra_info pete
262: WHERE pet.element_type_id = pel.element_type_id
263: AND pel.element_link_id = pee.element_link_id
264: AND pet.element_type_id = pete.element_type_id

Line 285: pay_element_types_f pet,

281: ) IS
282: SELECT peev.screen_entry_value
283: FROM pay_element_links_f pel,
284: pay_element_entries_f pee,
285: pay_element_types_f pet,
286: pay_element_type_extra_info pete,
287: pay_element_entry_values_f peev,
288: pay_input_values_f piv
289: WHERE pet.element_type_id = pel.element_type_id

Line 318: pay_element_types_f pet,

314: ) IS
315: SELECT peev.screen_entry_value
316: FROM pay_element_links_f pel,
317: pay_element_entries_f pee,
318: pay_element_types_f pet,
319: pay_element_type_extra_info pete,
320: pay_element_entry_values_f peev,
321: pay_input_values_f piv
322: WHERE pet.element_type_id = pel.element_type_id

Line 355: pay_element_types_f pet,

351: ,p_in_end_date IN DATE) IS
352: SELECT peev.screen_entry_value
353: FROM pay_element_links_f pel,
354: pay_element_entries_f pee,
355: pay_element_types_f pet,
356: pay_element_type_extra_info pete,
357: pay_element_entry_values_f peev,
358: pay_input_values_f piv
359: WHERE pet.element_type_id = pel.element_type_id

Line 388: pay_element_types_f pet,

384: ,p_in_end_date IN DATE) IS
385: SELECT peev.screen_entry_value
386: FROM pay_element_links_f pel,
387: pay_element_entries_f pee,
388: pay_element_types_f pet,
389: pay_element_type_extra_info pete,
390: pay_element_entry_values_f peev,
391: pay_input_values_f piv
392: WHERE pet.element_type_id = pel.element_type_id

Line 743: FROM pay_element_types_f_tl elementtl,

739:
740: CURSOR c_element_details
741: IS
742: SELECT element.element_type_id , link.element_link_id,element.business_group_id
743: FROM pay_element_types_f_tl elementtl,
744: pay_element_types_f element,
745: pay_element_links_f link,
746: per_all_assignments_f asgt ,
747: per_periods_of_service service_period

Line 744: pay_element_types_f element,

740: CURSOR c_element_details
741: IS
742: SELECT element.element_type_id , link.element_link_id,element.business_group_id
743: FROM pay_element_types_f_tl elementtl,
744: pay_element_types_f element,
745: pay_element_links_f link,
746: per_all_assignments_f asgt ,
747: per_periods_of_service service_period
748: WHERE

Line 1567: FROM pay_element_types_f

1563:
1564: CURSOR csr_get_element
1565: IS
1566: SELECT element_name
1567: FROM pay_element_types_f
1568: WHERE element_type_id = p_element_type_id
1569: AND p_effective_start_date BETWEEN effective_start_date AND effective_end_date
1570: AND legislation_code = 'GB';
1571:

Line 1589: l_element_name pay_element_types_f.element_name%TYPE;

1585: AND piv.name in ('Type','Reference','Order Amount','DEO Overriding Frequency')
1586: AND piv.legislation_code = 'GB'
1587: ORDER BY piv.name DESC;
1588:
1589: l_element_name pay_element_types_f.element_name%TYPE;
1590: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1591: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1592: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1593: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1730: FROM pay_element_types_f

1726:
1727: CURSOR csr_get_element
1728: IS
1729: SELECT element_name
1730: FROM pay_element_types_f
1731: WHERE element_type_id = p_element_type_id_o
1732: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1733: AND legislation_code = 'GB';
1734:

Line 1914: l_element_name pay_element_types_f.element_name%TYPE;

1910: -----------------------------
1911:
1912:
1913:
1914: l_element_name pay_element_types_f.element_name%TYPE;
1915: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1916: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1917: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1918: