DBA Data[Home] [Help]

APPS.PAY_UK_ELE_ENTRIES_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 102: from pay_element_entries_f e

98: pqp_gb_ad_ee.g_global_paye_validation := 'Y';
99:
100: select e.effective_end_date
101: into l_effective_end_date
102: from pay_element_entries_f e
103: where e.element_entry_id = x_element_entry_id
104: and x_session_date between e.effective_start_date and
105: e.effective_end_date;
106:

Line 215: pay_element_entries_f peef

211: select ppf.payroll_id
212: into l_payroll_id
213: from pay_payrolls_f ppf,
214: per_assignments_f paf,
215: pay_element_entries_f peef
216: where peef.element_entry_id = x_element_entry_id
217: and x_session_date between peef.effective_start_date and peef.effective_end_date
218: and peef.assignment_id = paf.assignment_id
219: and x_session_date between paf.effective_start_date and paf.effective_end_date

Line 256: from pay_element_entries_f e

252: end if;
253:
254: select e.effective_end_date
255: into l_effective_end_date
256: from pay_element_entries_f e
257: where e.element_entry_id = x_element_entry_id
258: and x_session_date between e.effective_start_date and
259: e.effective_end_date;
260: --