APPS.HR_REPORTS dependencies on PAY_PAYROLLS_F

Line 547: v_payroll_name pay_payrolls_f.payroll_name%type;

543: (p_session_date DATE,
544: p_payroll_id NUMBER) return VARCHAR2
545: --
546: AS
547: v_payroll_name pay_payrolls_f.payroll_name%type;
548: --
549: begin
550: --
551: hr_utility.trace('Entered hr_reports.get_payroll_name');

Line 561: from pay_payrolls_f p

557: begin
558: hr_utility.set_location('hr_reports.get_payroll_name',10);
559: select p.payroll_name
560: into v_payroll_name
561: from pay_payrolls_f p
562: where payroll_id = p_payroll_id
563: and p_session_date between
564: p.effective_start_date and
565: p.effective_end_date;