APPS.PA_PAXINGEN_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 21: org_name hr_organization_units.name%TYPE;

17: begin
18:
19: DECLARE
20: init_failure exception;
21: org_name hr_organization_units.name%TYPE;
22: member_name VARCHAR2(40);
23: role_type VARCHAR2(40);
24: enter_param VARCHAR2(80);
25: inv_status VARCHAR2(30);

Line 98: hr_organization_units where

94:
95: IF p_start_organization_id is not null then
96: begin
97: select substr(name, 1, 40) into org_name from
98: hr_organization_units where
99: organization_id = p_start_organization_id;
100: exception
101: when no_data_found then
102: null;