APPS.PA_ROLE_PROFILES_UTILS dependencies on PER_POSITIONS

Line 115: FROM per_positions

111: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
112:
113: CURSOR c_ids IS
114: SELECT position_id
115: FROM per_positions
116: WHERE name = p_position_name;
117: BEGIN
118: IF l_enable_log = 'Y' THEN
119: pa_debug.init_err_stack ('pa_role_profiles_utils.Check_Position_Name_Or_Id');

Line 148: FROM per_positions

144: ELSE
145: IF p_position_name IS NOT NULL THEN
146: SELECT position_id
147: INTO x_position_id
148: FROM per_positions
149: WHERE name = p_position_name;
150: ELSE x_position_id := NULL;
151: END IF;
152: END IF;

Line 325: FROM PER_POSITIONS

321: IF x_position_id IS NOT NULL THEN
322: BEGIN
323: SELECT 'Y'
324: INTO l_exists
325: FROM PER_POSITIONS
326: WHERE business_group_id = NVL(x_business_group_id, business_group_id)
327: AND organization_id = NVL(x_organization_id, organization_id)
328: AND job_id = NVL(x_job_id, job_id)
329: AND position_id = x_position_id;