APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1693: PAY_ELEMENT_ENTRY_VALUES_F peev

1689: CURSOR csr_chk_entry is
1690: select pee.ELEMENT_ENTRY_ID,
1691: pee.EFFECTIVE_START_DATE
1692: from PAY_ELEMENT_ENTRIES_F pee,
1693: PAY_ELEMENT_ENTRY_VALUES_F peev
1694: where pee.assignment_id = P_assignment_id
1695: --and P_session_date between pee.effective_start_date and
1696: -- pee.effective_end_date
1697: and pee.element_link_id = P_element_link_id

Line 1837: UPDATE pay_element_entry_values_f

1833: UPDATE pay_element_entries_f
1834: SET effective_start_date = P_effective_stdt
1835: WHERE element_entry_id = p_element_entry_id;
1836: -- entry values Values
1837: UPDATE pay_element_entry_values_f
1838: SET effective_start_date = P_effective_stdt
1839: WHERE element_entry_id = p_element_entry_id;
1840: END IF;
1841: end if;

Line 2540: FROM pay_element_entry_values_f peev,

2536: -- VERTEX element entries
2537: CURSOR vtx_info IS
2538: SELECT peev.screen_entry_value jurisdiction,
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

Line 2585: -- FROM pay_element_entry_values_f peev, pay_element_entries_f peef,

2581: --UPDATE pay_element_entry_values
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