DBA Data[Home] [Help]

APPS.PAY_UK_ELE_ENTRIES_PKG dependencies on PER_ASSIGNMENTS_F

Line 214: per_assignments_f paf,

210: if (x_entry_value5 = 'Irregular Periods') OR (x_entry_value5 = 'Multiple Periods') Then
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