APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_REQUEST_PVT

Line 266: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID )

262: from pa_probability_members
263: where probability_list_id =
264: (select probability_list_id from pa_project_types_all
265: where project_type = p_project_type
266: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID )
267: and probability_percentage = p_probability_percentage;
268:
269: BEGIN
270: IF (p_probability_member_id IS NOT NULL) THEN

Line 288: If PA_PROJECT_REQUEST_PVT.G_ORG_ID is null then -- Added the if condition for Bug#3807805

284: x_probability_member_id := NULL;
285: ELSE
286:
287: -- Find the ID which matches the Name passed
288: If PA_PROJECT_REQUEST_PVT.G_ORG_ID is null then -- Added the if condition for Bug#3807805
289: OPEN c_ids;
290: LOOP
291: FETCH c_ids INTO l_current_id;
292: EXIT WHEN c_ids%NOTFOUND;

Line 333: If PA_PROJECT_REQUEST_PVT.G_ORG_ID is null then -- Added the if condition for Bug#3807805

329: ELSE
330: IF (p_probability_percentage IS NOT NULL) THEN
331:
332: IF (p_probability_list_id IS NULL) THEN
333: If PA_PROJECT_REQUEST_PVT.G_ORG_ID is null then -- Added the if condition for Bug#3807805
334: select probability_member_id
335: into x_probability_member_id
336: from pa_probability_members
337: where probability_list_id =

Line 348: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID ) --MOAC Changes: Bug 4363092: removed nvl usage with org_id

344: from pa_probability_members
345: where probability_list_id =
346: (select probability_list_id from pa_project_types_all where
347: project_type = p_project_type
348: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID ) --MOAC Changes: Bug 4363092: removed nvl usage with org_id
349: and probability_percentage = p_probability_percentage;
350: end if;
351: ELSE
352: SELECT probability_member_id