APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 264: (select probability_list_id from pa_project_types_all

260: CURSOR c_ids1 IS -- Added the cursor for Bug#3807805
261: select probability_member_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:

Line 346: (select probability_list_id from pa_project_types_all where

342: select probability_member_id
343: into x_probability_member_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;

Line 1387: PA_PROJECT_TYPES_ALL ppta

1383: IS
1384: SELECT 1
1385: FROM PA_VALID_CATEGORIES vc,
1386: PA_PROJECTS_ALL ppa,
1387: PA_PROJECT_TYPES_ALL ppta
1388: WHERE vc.mandatory_flag = 'Y'
1389: AND vc.class_category = c_class_category
1390: AND ppa.project_id = p_object_id
1391: AND ppa.project_type = ppta.project_type

Line 1666: PA_PROJECT_TYPES_ALL ppta

1662: IS
1663: SELECT total_100_percent_flag
1664: FROM PA_VALID_CATEGORIES_V vc,
1665: PA_PROJECTS_ALL ppa,
1666: PA_PROJECT_TYPES_ALL ppta
1667: WHERE ppa.project_id = p_object_id
1668: AND ppa.project_type = ppta.project_type
1669: AND nvl(ppa.org_id, -99) = nvl(ppta.org_id, -99)
1670: AND vc.object_type_id = ppta.project_type_id

Line 1736: FROM PA_PROJECT_TYPES_ALL ppta,

1732: IS
1733: CURSOR C1
1734: IS
1735: SELECT ppta.project_type_id
1736: FROM PA_PROJECT_TYPES_ALL ppta,
1737: PA_PROJECTS_ALL ppa
1738: WHERE ppa.project_id = p_object_id
1739: AND ppa.project_type = ppta.project_type
1740: AND ppa.org_id = ppta.org_id; --MOAC Changes: Bug 4363092: removed nvl usage with org_id

Line 2228: FROM pa_project_types_all pta

2224: SELECT mandatory_flag
2225: FROM pa_valid_categories pvc
2226: WHERE class_category = p_class_category
2227: AND EXISTS (SELECT 'X'
2228: FROM pa_project_types_all pta
2229: WHERE pta.project_type_id = pvc.object_type_id
2230: AND EXISTS (SELECT 'X'
2231: FROM pa_projects_all ppa
2232: WHERE pta.project_type = ppa.project_type