DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PAY_ALL_PAYROLLS_F

Line 1468: from pay_all_payrolls_f prl

1464: --
1465: cursor c_PayrollNameLovVO(p_source_name1 varchar2, cv_effective_date date) is
1466: select prl.payroll_name name /* cg$fk */ ,
1467: prl.payroll_id id
1468: from pay_all_payrolls_f prl
1469: where trunc(cv_effective_date)
1470: between prl.effective_start_date and prl.effective_end_date
1471: and prl.business_group_id + 0 = p_target_business_group_id
1472: and prl.payroll_name = p_source_name1;