APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1692: from PAY_ELEMENT_ENTRIES_F pee,

1688:
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

Line 1833: UPDATE pay_element_entries_f

1829: P_effective_stdt := p_session_date;
1830: -- change effective start date to new date
1831: -- Changed March 31, 1997
1832: -- Entries
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

Line 1917: from PAY_ELEMENT_ENTRIES_F pee

1913:
1914: CURSOR csr_chk_entry is
1915: select pee.ELEMENT_ENTRY_ID,
1916: pee.EFFECTIVE_START_DATE
1917: from PAY_ELEMENT_ENTRIES_F pee
1918: where pee.assignment_id = P_assignment_id
1919: and P_session_date between pee.effective_start_date and
1920: pee.effective_end_date
1921: and pee.element_link_id = P_element_link_id;

Line 2541: pay_element_entries_f peef,

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
2545: WHERE pet.element_name = 'VERTEX'

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