APPS.PAY_DK_LABOR_COST_REPORT dependencies on PAY_PAYROLLS_F

Line 15: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

11: ,p_template_name VARCHAR2
12: ,p_xml OUT NOCOPY CLOB) IS
13:
14: l_legal_employer_name hr_organization_units.name%TYPE;
15: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
16: l_business_group_id hr_organization_units.business_group_id%TYPE;
17: l_string VARCHAR2(32767) := NULL;
18: l_xml CLOB;
19:

Line 69: pay_payrolls_f pay

65: CURSOR csr_payroll_name(p_payroll_id NUMBER, p_effective_date DATE) IS
66: SELECT
67: pay.payroll_name
68: FROM
69: pay_payrolls_f pay
70: WHERE pay.payroll_id = p_payroll_id
71: AND p_effective_date BETWEEN pay.effective_start_date AND pay.effective_end_date;
72: ---------------------
73: CURSOR csr_global_value(p_global_name VARCHAR2,