APPS.PA_PAXPCIFS_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 22: org_name hr_organization_units.name%TYPE;

18:
19: Declare
20: init_failure exception;
21: ndf VARCHAR2(80);
22: org_name hr_organization_units.name%TYPE;
23: member_name VARCHAR2(240);
24: role_type VARCHAR2(80);
25: enter_param VARCHAR2(80);
26: BEGIN

Line 58: select Substr(name, 1, 60) into org_name from hr_organization_units where organization_id = p_start_organization_id;

54: lookup_code = 'ENTER_ORG_MGR';
55: end if;
56: c_enter := enter_param;
57: If p_start_organization_id is not null then
58: select Substr(name, 1, 60) into org_name from hr_organization_units where organization_id = p_start_organization_id;
59: end if;
60: c_start_org := org_name;
61:
62: IF project_member is not null then