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 6132: PAY_ELEMENT_TYPES_F pet

6128: peef.effective_start_date start_date
6129: from PAY_ELEMENT_ENTRY_VALUES_F peev,
6130: PAY_ELEMENT_ENTRIES_F peef,
6131: PAY_INPUT_VALUES_F piv,
6132: PAY_ELEMENT_TYPES_F pet
6133: where pet.element_name = 'VERTEX'
6134: and pet.element_type_id = piv.element_type_id
6135: and piv.name = 'Jurisdiction'
6136: and piv.input_value_id = 0 + peev.input_value_id

Line 7061: PAY_ELEMENT_TYPES_F pet

7057: select pet.element_type_id,
7058: piv.input_value_id,
7059: piv.name
7060: from PAY_INPUT_VALUES_F piv,
7061: PAY_ELEMENT_TYPES_F pet
7062: where p_session_date between piv.effective_start_date
7063: and piv.effective_end_date
7064: and pet.element_type_id = piv.element_type_id
7065: and p_session_date between pet.effective_start_date

Line 7441: from PAY_ELEMENT_TYPES_F pet

7437: /* Cursor to get the workers comp. element type */
7438:
7439: cursor csr_tax_element is
7440: select pet.element_type_id
7441: from PAY_ELEMENT_TYPES_F pet
7442: where pet.element_name = 'Workers Compensation' -- Bug 3354060 FTS on PAY_ELEMENT_TYPES_F was removed. Done by removing
7443: and p_session_date between pet.effective_start_date -- 'upper' from pet.element_name and 'WORKERS COMPENSATION' was changed to
7444: and pet.effective_end_date; -- 'Workers Compensation'
7445:

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

7438:
7439: cursor csr_tax_element is
7440: select pet.element_type_id
7441: from PAY_ELEMENT_TYPES_F pet
7442: where pet.element_name = 'Workers Compensation' -- Bug 3354060 FTS on PAY_ELEMENT_TYPES_F was removed. Done by removing
7443: and p_session_date between pet.effective_start_date -- 'upper' from pet.element_name and 'WORKERS COMPENSATION' was changed to
7444: and pet.effective_end_date; -- 'Workers Compensation'
7445:
7446: /* Cursor to get the element entry for the jurisdiction */

Line 7747: from PAY_ELEMENT_TYPES_F pet

7743:
7744: /* Get the Vertex element type */
7745: cursor csr_tax_element is
7746: select pet.element_type_id
7747: from PAY_ELEMENT_TYPES_F pet
7748: where pet.element_name = 'VERTEX'
7749: and p_session_date between pet.effective_start_date
7750: and pet.effective_end_date;
7751:

Line 8027: from PAY_ELEMENT_TYPES_F pet

8023:
8024: /* Get the Vertex element type */
8025: cursor csr_tax_element is
8026: select pet.element_type_id
8027: from PAY_ELEMENT_TYPES_F pet
8028: where pet.element_name = 'VERTEX'
8029: and p_session_date between pet.effective_start_date
8030: and pet.effective_end_date;
8031:

Line 9071: from PAY_ELEMENT_TYPES_F pet

9067:
9068: /* Get the Vertex element type */
9069: cursor csr_tax_element is
9070: select pet.element_type_id
9071: from PAY_ELEMENT_TYPES_F pet
9072: where pet.element_name = 'VERTEX'
9073: and p_session_date between pet.effective_start_date
9074: and pet.effective_end_date;
9075: