APPS.PA_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 286: hr_organization_units o,

282: organization_id
283: INTO
284: X_org_id
285: FROM
286: hr_organization_units o,
287: pa_implementations i
288: WHERE name = X_org_name
289: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
290: AND o.business_group_id = i.business_group_id)

Line 321: hr_organization_units o,

317: organization_id
318: INTO
319: X_orgn_id
320: FROM
321: hr_organization_units o,
322: pa_implementations i
323: WHERE name = X_org_name
324: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
325: AND o.business_group_id = i.business_group_id)

Line 334: hr_organization_units o,

330: organization_id
331: INTO
332: X_orgn_id
333: FROM
334: hr_organization_units o,
335: pa_implementations i
336: WHERE name = X_org_name
337: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'
338: AND o.business_group_id = i.business_group_id)

Line 361: X_org_name hr_organization_units.name%TYPE;

357: FUNCTION GetOrgName ( X_org_id IN NUMBER ) RETURN VARCHAR2
358: IS
359: /* Bug No:- 2487147, UTF8 change : changed X_org_name to %TYPE */
360: /* X_org_name VARCHAR2(60); */
361: X_org_name hr_organization_units.name%TYPE;
362: BEGIN
363: SELECT
364: name
365: INTO

Line 368: hr_organization_units o,

364: name
365: INTO
366: X_org_name
367: FROM
368: hr_organization_units o,
369: pa_implementations i
370: WHERE
371: organization_id = X_org_id
372: AND ((pa_utils.IsCrossBGProfile_WNPS = 'N'