DBA Data[Home] [Help]

APPS.PA_PAXAUMTC_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 25: org_name hr_organization_units.name%TYPE;

21: hold_employee_name VARCHAR2(40);
22: p_date_lo date;
23: p_date_hi date;
24: code VARCHAR2(80);
25: org_name hr_organization_units.name%TYPE;
26: person_name VARCHAR2(30);
27: start_day NUMBER;
28:
29: BEGIN

Line 80: hr_organization_units

76: c_employee_name := hold_employee_name;
77: IF incurred_org is not null then
78: select substr(name,1,30)
79: into org_name from
80: hr_organization_units
81: where organization_id = incurred_org;
82: END IF;
83: c_incurred_org := org_name;
84: