APPS.PA_PAXEMRAO_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 22: org_name hr_organization_units.name%TYPE;

18:
19: Declare
20: init_failure exception;
21: hold_employee_name VARCHAR2(50);
22: org_name hr_organization_units.name%TYPE;
23: yes_no VARCHAR2(40);
24: BEGIN
25:
26: CP_DATE_LO := TO_CHAR(DATE_LO,'DD-MON-YY');

Line 58: from hr_organization_units

54:
55: if start_org_id is not null then
56: select substr(name,1,40)
57: into org_name
58: from hr_organization_units
59: where organization_id = start_org_id;
60: end if;
61: c_org_name := org_name;
62: