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 335: hr_organization_units o,

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

Line 362: X_org_name hr_organization_units.name%TYPE;

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

Line 369: hr_organization_units o,

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