APPS.PJI_PMV_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 15: x_top_org_name OUT nocopy hr_all_organization_units_tl.name%TYPE,

11: --> x_insert_top_org : Flag indicating whether the user has permissions to the see the top org in the
12: -- hierarchy
13: PROCEDURE get_top_org_details
14: (x_top_org_id OUT nocopy per_security_profiles.organization_id%TYPE,
15: x_top_org_name OUT nocopy hr_all_organization_units_tl.name%TYPE,
16: x_user_assmt_flag OUT nocopy VARCHAR2,
17: x_insert_top_org_flag OUT nocopy VARCHAR2 )
18: IS
19: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

Line 64: FROM hr_all_organization_units_tl

60: IF x_insert_top_org_flag = 'Y' THEN
61:
62: SELECT name
63: INTO x_top_org_name
64: FROM hr_all_organization_units_tl
65: WHERE organization_id = x_top_org_id
66: AND language = USERENV('LANG');
67:
68: END IF;

Line 86: l_top_org_name hr_all_organization_units_tl.name%TYPE;

82: FUNCTION PJI_ORGANIZATION_EXISTS(p_org_id IN NUMBER) RETURN NUMBER
83: IS
84: l_top_organization_id per_security_profiles.organization_id%TYPE;
85: l_org_id per_security_profiles.organization_id%TYPE;
86: l_top_org_name hr_all_organization_units_tl.name%TYPE;
87: l_user_assmt_flag VARCHAR2(1);
88: l_insert_top_org_flag VARCHAR2(1);
89:
90: BEGIN