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.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1674: from PAY_ELEMENT_TYPES_F pet,

1670: CURSOR csr_tax_element is
1671: select pet.ELEMENT_TYPE_ID,
1672: piv.INPUT_VALUE_ID,
1673: piv.NAME
1674: from PAY_ELEMENT_TYPES_F pet,
1675: PAY_INPUT_VALUES_F piv
1676: where PET.ELEMENT_NAME = 'VERTEX'
1677: and P_session_date between pet.effective_start_date and
1678: pet.effective_end_date

Line 1901: piv.INPUT_VALUE_ID, -- changed to Workers Compensation to remove FTS on pay_element_types_f.

1897:
1898: -- Cursor to get the Workers Compensation element and link
1899: CURSOR csr_wc_element is
1900: select pet.ELEMENT_TYPE_ID, -- Bug 3354046: Upper clause is removed around pet.element_name and WORKERS COMPENSATION
1901: piv.INPUT_VALUE_ID, -- changed to Workers Compensation to remove FTS on pay_element_types_f.
1902: piv.NAME
1903: from PAY_ELEMENT_TYPES_F pet,
1904: PAY_INPUT_VALUES_F piv
1905: where PET.ELEMENT_NAME = 'Workers Compensation'

Line 1903: from PAY_ELEMENT_TYPES_F pet,

1899: CURSOR csr_wc_element is
1900: select pet.ELEMENT_TYPE_ID, -- Bug 3354046: Upper clause is removed around pet.element_name and WORKERS COMPENSATION
1901: piv.INPUT_VALUE_ID, -- changed to Workers Compensation to remove FTS on pay_element_types_f.
1902: piv.NAME
1903: from PAY_ELEMENT_TYPES_F pet,
1904: PAY_INPUT_VALUES_F piv
1905: where PET.ELEMENT_NAME = 'Workers Compensation'
1906: and P_session_date between pet.effective_start_date and
1907: pet.effective_end_date

Line 2544: pay_element_types_f pet

2540: FROM pay_element_entry_values_f peev,
2541: pay_element_entries_f peef,
2542: pay_element_links_f pel,
2543: pay_input_values_f piv,
2544: pay_element_types_f pet
2545: WHERE pet.element_name = 'VERTEX'
2546: AND pet.element_type_id = piv.element_type_id
2547: AND pel.element_type_id = pet.element_type_id
2548: AND peef.element_link_id = pel.element_link_id

Line 2587: -- pay_element_types_f pet

2583: --WHERE element_entry_value_id in
2584: --( SELECT peev.element_entry_value_id
2585: -- FROM pay_element_entry_values_f peev, pay_element_entries_f peef,
2586: -- pay_input_values_f piv,
2587: -- pay_element_types_f pet
2588: -- WHERE pet.element_name = 'VERTEX'
2589: -- AND pet.element_type_id = piv.element_type_id
2590: -- AND piv.input_value_id = 0 + peev.input_value_id
2591: -- AND peev.element_entry_id = peef.element_entry_id