APPS.PJI_PMV_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

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

Line 105: , hr_all_organization_units org

101: (SELECT orgd.organization_id_child
102: FROM
103: per_org_structure_elements orgd
104: , pji_system_settings pset
105: , hr_all_organization_units org
106: WHERE 1=1
107: AND orgd.org_structure_version_id = pset.org_structure_version_id
108: AND orgd.organization_id_child = org.organization_id
109: AND org.organization_id = p_org_id);

Line 120: , hr_all_organization_units org

116: FROM
117: per_org_structure_elements orgd
118: , pji_system_settings pset
119: , per_organization_list sec
120: , hr_all_organization_units org
121: WHERE 1=1
122: AND orgd.org_structure_version_id = pset.org_structure_version_id
123: AND orgd.organization_id_child = org.organization_id
124: AND org.organization_id = p_org_id

Line 136: , hr_all_organization_units org

132: (SELECT orgd.organization_id_child
133: FROM
134: per_org_structure_elements orgd
135: , pji_system_settings pset
136: , hr_all_organization_units org
137: WHERE 1=1
138: AND orgd.org_structure_version_id = pset.org_structure_version_id
139: AND orgd.organization_id_child = org.organization_id
140: AND orgd.organization_id_child = p_org_id

Line 171: , hr_all_organization_units org

167: per_org_structure_elements c
168: where c.organization_id_child = p.organization_id_parent
169: and c.org_structure_version_id = p.org_structure_version_id)) orgd
170: , per_organization_list sec
171: , hr_all_organization_units org
172: , per_security_profiles prof
173: WHERE 1=1
174: AND orgd.organization_id_child = org.organization_id
175: AND orgd.organization_id_child = p_org_id