APPS.PSP_ENC_CRT_XML dependencies on HR_ALL_ORGANIZATION_UNITS

Line 16: l_org_name hr_all_organization_units_tl.name%TYPE;

12: l_chart_of_accts VARCHAR2(20); gl_flex_values VARCHAR2(2000);
13: l_project_number pa_projects_all.segment1%TYPE;
14: l_award_number VARCHAR2(15);
15: l_task_number VARCHAR2(25);
16: l_org_name hr_all_organization_units_tl.name%TYPE;
17: BEGIN
18:
19: IF p_gl_code_combination_id IS NOT NULL
20: THEN

Line 45: FROM hr_all_organization_units

41: WHERE award_id = p_award_id;
42:
43: SELECT name
44: INTO l_org_name
45: FROM hr_all_organization_units
46: WHERE organization_id = p_expenditure_organization_id;
47: RETURN(l_project_number||','||l_task_number||','||l_award_number
48: ||','||l_org_name||','||p_expenditure_type);
49: END IF;