DBA Data[Home] [Help]

APPS.PAY_UK_ELE_ENTRIES_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 90: from pay_element_entries_f e

86: P_entry_information2 => x_entry_information2,
87: P_entry_information_category => x_entry_information_category);
88: select e.effective_end_date
89: into l_effective_end_date
90: from pay_element_entries_f e
91: where e.element_entry_id = x_element_entry_id
92: and x_session_date between e.effective_start_date and
93: e.effective_end_date;
94:

Line 203: pay_element_entries_f peef

199: select ppf.payroll_id
200: into l_payroll_id
201: from pay_payrolls_f ppf,
202: per_assignments_f paf,
203: pay_element_entries_f peef
204: where peef.element_entry_id = x_element_entry_id
205: and x_session_date between peef.effective_start_date and peef.effective_end_date
206: and peef.assignment_id = paf.assignment_id
207: and x_session_date between paf.effective_start_date and paf.effective_end_date

Line 244: from pay_element_entries_f e

240: end if;
241:
242: select e.effective_end_date
243: into l_effective_end_date
244: from pay_element_entries_f e
245: where e.element_entry_id = x_element_entry_id
246: and x_session_date between e.effective_start_date and
247: e.effective_end_date;
248: --