APPS.PA_PAXMGPBS_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 22: org_name hr_organization_units.name%TYPE;

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

Line 68: select substr(name,1,60) into org_name from hr_organization_units where

64: end if;
65: c_enter := enter_param;
66:
67: If p_start_organization_id is not null then
68: select substr(name,1,60) into org_name from hr_organization_units where
69: organization_id = p_start_organization_id;
70: end if;
71: c_start_org := org_name;
72: