APPS.PA_PAXRWSBR_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 21: hold_org_name hr_organization_units.name%TYPE;

17: begin
18:
19: Declare
20: init_failure exception;
21: hold_org_name hr_organization_units.name%TYPE;
22:
23: BEGIN
24:
25: EFFECTIVE_DATE1:=to_char(EFFECTIVE_DATE,'DD-MON-YY');

Line 44: from hr_organization_units

40: If organization_id is not null
41: then
42: select substr(name, 1, 60)
43: into hold_org_name
44: from hr_organization_units
45: where organization_id = PA_PAXRWSBR_XMLP_PKG.organization_id;
46: c_org_name := hold_org_name;
47: end if;
48: