DBA Data[Home] [Help]

APPS.PAY_GB_DEO dependencies on PAY_PAYROLLS_F

Line 765: from pay_payrolls_f ppf

761:
762: cursor get_payroll_name(p_payroll_id IN varchar2,p_business_group_id IN number,p_effective_date IN date)
763: is
764: select ppf.payroll_name
765: from pay_payrolls_f ppf
766: where ppf.payroll_id = p_payroll_id
767: and ppf.business_group_id = p_business_group_id
768: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
769:

Line 818: from pay_payrolls_f ppf

814:
815: cursor get_payroll_name(p_payroll_id IN varchar2,p_business_group_id IN number,p_effective_date IN date)
816: is
817: select ppf.payroll_name
818: from pay_payrolls_f ppf
819: where ppf.payroll_id = p_payroll_id
820: and ppf.business_group_id = p_business_group_id
821: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
822: