APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_INPUT_VALUES_F

Line 1675: PAY_INPUT_VALUES_F piv

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
1679: and pet.element_type_id = piv.element_type_id

Line 1904: PAY_INPUT_VALUES_F piv

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
1908: and pet.element_type_id = piv.element_type_id

Line 2543: pay_input_values_f piv,

2539: peef.effective_start_date start_date
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

Line 2586: -- pay_input_values_f piv,

2582: --SET screen_entry_value = '0'
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