APPS.PAY_DK_LABOR_COST_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 14: l_legal_employer_name hr_organization_units.name%TYPE;

10: ,p_year NUMBER
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;

Line 16: l_business_group_id hr_organization_units.business_group_id%TYPE;

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:
20: l_value_0050 NUMBER := 0;

Line 62: hr_organization_units hou

58: CURSOR csr_legal_employer_details(p_legal_employer_id NUMBER) IS
59: SELECT
60: hou.name, hou.business_group_id
61: FROM
62: hr_organization_units hou
63: WHERE hou.organization_id = p_legal_employer_id;
64: ---------------------
65: CURSOR csr_payroll_name(p_payroll_id NUMBER, p_effective_date DATE) IS
66: SELECT