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_INPUT_VALUES_F

Line 146: pay_input_values_f piv

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
147: WHERE pet.element_type_id = pel.element_type_id
148: AND pel.element_link_id = pee.element_link_id
149: AND pet.element_type_id = pete.element_type_id
150: AND pee.assignment_id = asg.assignment_id

Line 288: pay_input_values_f piv

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
290: AND pel.element_link_id = pee.element_link_id
291: AND pet.element_type_id = pete.element_type_id
292: AND peev.element_entry_id = pee.element_entry_id

Line 321: pay_input_values_f piv

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
323: AND pel.element_link_id = pee.element_link_id
324: AND pet.element_type_id = pete.element_type_id
325: AND peev.element_entry_id = pee.element_entry_id

Line 358: pay_input_values_f piv

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
360: AND pel.element_link_id = pee.element_link_id
361: AND pet.element_type_id = pete.element_type_id
362: AND peev.element_entry_id = pee.element_entry_id

Line 391: pay_input_values_f piv

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
393: AND pel.element_link_id = pee.element_link_id
394: AND pet.element_type_id = pete.element_type_id
395: AND peev.element_entry_id = pee.element_entry_id

Line 1539: pay_input_values_f piv

1535:
1536: SELECT max(decode (piv.name, 'Category', peev.screen_entry_value)) Category,
1537: max(decode (piv.name,'Pension', peev.screen_entry_value)) Pension
1538: FROM pay_element_entry_values_f peev,
1539: pay_input_values_f piv
1540: WHERE peev.element_entry_id = p_element_type_id
1541: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1542: AND peev.input_value_id = piv.input_value_id
1543: AND piv.element_type_id = p_element_type_id

Line 1579: pay_input_values_f piv

1575: max (decode (piv.name,'Reference', peev.screen_entry_value)),
1576: max (decode (piv.name,'Order Amount', peev.screen_entry_value)),
1577: max (decode (piv.name,'DEO Overriding Frequency', peev.screen_entry_value))
1578: FROM pay_element_entry_values_f peev,
1579: pay_input_values_f piv
1580: WHERE peev.element_entry_id = p_element_entry_id
1581: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1582: AND peev.input_value_id = piv.input_value_id
1583: AND piv.element_type_id = p_element_type_id

Line 1717: pay_input_values_f piv

1713:
1714: SELECT max(decode (piv.name, 'Category', peev.screen_entry_value)) Category,
1715: max(decode (piv.name,'Pension', peev.screen_entry_value)) Pension
1716: FROM pay_element_entry_values_f peev,
1717: pay_input_values_f piv
1718: WHERE peev.element_entry_id = p_element_entry_id
1719: AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1720: AND peev.input_value_id = piv.input_value_id
1721: AND piv.element_type_id = p_element_type_id_o

Line 1742: pay_input_values_f piv

1738: max (decode (piv.name,'Reference', peev.screen_entry_value)),
1739: max (decode (piv.name,'Order Amount', peev.screen_entry_value)),
1740: max (decode (piv.name,'DEO Overriding Frequency', peev.screen_entry_value))
1741: FROM pay_element_entry_values_f peev,
1742: pay_input_values_f piv
1743: WHERE peev.element_entry_id = p_element_entry_id
1744: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1745: AND peev.input_value_id = piv.input_value_id
1746: AND piv.element_type_id = p_element_type_id_o

Line 1773: pay_input_values_f piv ,

1769: SELECT nvl(prrv.result_value,'Unknown')
1770: FROM pay_run_results prr,
1771: pay_run_result_values prrv,
1772: pay_assignment_actions pac,
1773: pay_input_values_f piv ,
1774: pay_payroll_actions ppa
1775: WHERE prr.run_result_id = prrv.run_result_id
1776: AND prr.entry_type = 'E'
1777: AND PRR.source_type IN ('E', 'I')

Line 1887: pay_input_values_f piv

1883: CURSOR csr_get_tax_code
1884: IS
1885: SELECT max (decode (piv.name, 'Tax Code', peev.screen_entry_value))
1886: FROM pay_element_entry_values_f peev,
1887: pay_input_values_f piv
1888: WHERE peev.element_entry_id = p_element_entry_id
1889: AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1890: AND peev.input_value_id = piv.input_value_id
1891: AND piv.element_type_id = p_element_type_id_o