DBA Data[Home] [Help]

APPS.PER_ASG_BUS2 dependencies on PAY_ALL_PAYROLLS_F

Line 287: from pay_all_payrolls_f pp

283: cursor csr_payroll_exists is
284: select null
285: from sys.dual
286: where exists(select null
287: from pay_all_payrolls_f pp
288: where p_effective_date
289: between pp.effective_start_date
290: and pp.effective_end_date
291: and pp.payroll_id = p_payroll_id);

Line 295: from pay_all_payrolls_f

291: and pp.payroll_id = p_payroll_id);
292: --
293: cursor csr_get_bus_grp is
294: select business_group_id
295: from pay_all_payrolls_f
296: where payroll_id = p_payroll_id
297: and p_effective_date between effective_start_date
298: and effective_end_date;
299: --