APPS.PA_PAXPCTCE_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(240);
22: org_name hr_organization_units.name%TYPE;
23:
24: BEGIN
25: DATE_LOW_1:=to_char(DATE_LOW,'DD-MON-YY');
26: DATE_HIGH_1:=to_char(DATE_HIGH,'DD-MON-YY');

Line 43: hr_organization_units

39:
40: IF incurred_org is not null then
41: select substr(name,1,30)
42: into org_name from
43: hr_organization_units
44: where organization_id = incurred_org;
45: END IF;
46: c_incurred_org := org_name;
47: