APPS.PA_WORKPLAN_ATTR_UTILS dependencies on PA_PEOPLE_LOV_V

Line 185: FROM pa_people_lov_v

181: l_id_found_flag VARCHAR(1) := 'N';
182:
183: CURSOR c_ids IS
184: SELECT resource_source_id, resource_type_id
185: FROM pa_people_lov_v
186: WHERE name = p_approver_name;
187:
188: BEGIN
189: if (p_approver_source_id = FND_API.G_MISS_NUM) OR (p_approver_source_id is NULL) then

Line 193: FROM pa_people_lov_v

189: if (p_approver_source_id = FND_API.G_MISS_NUM) OR (p_approver_source_id is NULL) then
190: if (p_approver_name is not NULL) then
191: SELECT resource_source_id, resource_type_id
192: INTO x_approver_source_id, x_approver_source_type
193: FROM pa_people_lov_v
194: WHERE name = p_approver_name;
195: else
196: x_approver_source_id := NULL;
197: x_approver_source_type := NULL;

Line 203: FROM pa_people_lov_v

199: else
200: if p_check_id_flag = 'Y' then
201: SELECT resource_source_id, resource_type_id
202: INTO x_approver_source_id, x_approver_source_type
203: FROM pa_people_lov_v
204: WHERE resource_source_id = p_approver_source_id
205: AND resource_type_id = p_approver_source_type;
206: ELSIF (p_check_id_flag='N') THEN
207: x_approver_source_id := p_approver_source_id;