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

Line 62: PAY_ELEMENT_TYPES_F pet

58: select pet.element_type_id,
59: piv.input_value_id,
60: piv.name
61: from PAY_INPUT_VALUES_F piv,
62: PAY_ELEMENT_TYPES_F pet
63: where p_session_date between piv.effective_start_date
64: and piv.effective_end_date
65: and pet.element_type_id = piv.element_type_id
66: and p_session_date between pet.effective_start_date

Line 347: PAY_ELEMENT_TYPES_F pet

343: select pet.element_type_id,
344: piv.input_value_id,
345: piv.name
346: from PAY_INPUT_VALUES_F piv,
347: PAY_ELEMENT_TYPES_F pet
348: where p_session_date between piv.effective_start_date
349: and piv.effective_end_date
350: and pet.element_type_id = piv.element_type_id
351: and p_session_date between pet.effective_start_date

Line 353: and pet.element_name = 'Workers Compensation'; -- Bug 3354060 FTS on PAY_ELEMENT_TYPES_F was removed. Done by removing

349: and piv.effective_end_date
350: and pet.element_type_id = piv.element_type_id
351: and p_session_date between pet.effective_start_date
352: and pet.effective_end_date
353: and pet.element_name = 'Workers Compensation'; -- Bug 3354060 FTS on PAY_ELEMENT_TYPES_F was removed. Done by removing
354: -- 'upper' from pet.element_name and 'WORKERS COMPENSATION' was changed to
355: -- 'Workers Compensation'
356:
357:

Line 6056: PAY_ELEMENT_TYPES_F pet

6052: peef.effective_start_date start_date
6053: from PAY_ELEMENT_ENTRY_VALUES_F peev,
6054: PAY_ELEMENT_ENTRIES_F peef,
6055: PAY_INPUT_VALUES_F piv,
6056: PAY_ELEMENT_TYPES_F pet
6057: where pet.element_name = 'VERTEX'
6058: and pet.element_type_id = piv.element_type_id
6059: and piv.name = 'Jurisdiction'
6060: and piv.input_value_id = 0 + peev.input_value_id

Line 6985: PAY_ELEMENT_TYPES_F pet

6981: select pet.element_type_id,
6982: piv.input_value_id,
6983: piv.name
6984: from PAY_INPUT_VALUES_F piv,
6985: PAY_ELEMENT_TYPES_F pet
6986: where p_session_date between piv.effective_start_date
6987: and piv.effective_end_date
6988: and pet.element_type_id = piv.element_type_id
6989: and p_session_date between pet.effective_start_date

Line 7365: from PAY_ELEMENT_TYPES_F pet

7361: /* Cursor to get the workers comp. element type */
7362:
7363: cursor csr_tax_element is
7364: select pet.element_type_id
7365: from PAY_ELEMENT_TYPES_F pet
7366: where pet.element_name = 'Workers Compensation' -- Bug 3354060 FTS on PAY_ELEMENT_TYPES_F was removed. Done by removing
7367: and p_session_date between pet.effective_start_date -- 'upper' from pet.element_name and 'WORKERS COMPENSATION' was changed to
7368: and pet.effective_end_date; -- 'Workers Compensation'
7369:

Line 7366: where pet.element_name = 'Workers Compensation' -- Bug 3354060 FTS on PAY_ELEMENT_TYPES_F was removed. Done by removing

7362:
7363: cursor csr_tax_element is
7364: select pet.element_type_id
7365: from PAY_ELEMENT_TYPES_F pet
7366: where pet.element_name = 'Workers Compensation' -- Bug 3354060 FTS on PAY_ELEMENT_TYPES_F was removed. Done by removing
7367: and p_session_date between pet.effective_start_date -- 'upper' from pet.element_name and 'WORKERS COMPENSATION' was changed to
7368: and pet.effective_end_date; -- 'Workers Compensation'
7369:
7370: /* Cursor to get the element entry for the jurisdiction */

Line 7671: from PAY_ELEMENT_TYPES_F pet

7667:
7668: /* Get the Vertex element type */
7669: cursor csr_tax_element is
7670: select pet.element_type_id
7671: from PAY_ELEMENT_TYPES_F pet
7672: where pet.element_name = 'VERTEX'
7673: and p_session_date between pet.effective_start_date
7674: and pet.effective_end_date;
7675:

Line 7951: from PAY_ELEMENT_TYPES_F pet

7947:
7948: /* Get the Vertex element type */
7949: cursor csr_tax_element is
7950: select pet.element_type_id
7951: from PAY_ELEMENT_TYPES_F pet
7952: where pet.element_name = 'VERTEX'
7953: and p_session_date between pet.effective_start_date
7954: and pet.effective_end_date;
7955:

Line 8995: from PAY_ELEMENT_TYPES_F pet

8991:
8992: /* Get the Vertex element type */
8993: cursor csr_tax_element is
8994: select pet.element_type_id
8995: from PAY_ELEMENT_TYPES_F pet
8996: where pet.element_name = 'VERTEX'
8997: and p_session_date between pet.effective_start_date
8998: and pet.effective_end_date;
8999: