DBA Data[Home] [Help]

APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1070: pay_element_entries_f peef,

1066:
1067: cursor csr_tax_status (p_run_assact_id number, p_input_value_name varchar2)is
1068: select max(peevf.screen_entry_value)
1069: from pay_element_entry_values_f peevf,
1070: pay_element_entries_f peef,
1071: pay_link_input_values_f plivf,
1072: pay_input_values_f pivf,
1073: pay_element_types_f petf,
1074: pay_payroll_actions ppa,

Line 1096: from pay_element_entries_f peef2

1092: and peevf.element_entry_id = peef.element_entry_id
1093: and peef.effective_start_date =
1094: (
1095: select max(peef2.effective_start_date)
1096: from pay_element_entries_f peef2
1097: where peef2.effective_start_date <= ppa.effective_date
1098: and peef2.element_link_id = plivf.element_link_id
1099: and peef2.assignment_id = paa.assignment_id
1100: )