APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_TYPES

Line 255: (select probability_list_id from pa_project_types where

251: CURSOR c_ids IS
252: select probability_member_id
253: from pa_probability_members
254: where probability_list_id =
255: (select probability_list_id from pa_project_types where
256: project_type = p_project_type)
257: and probability_percentage = p_probability_percentage;
258:
259: --MOAC Changes: Bug 4363092: removed nvl usage with org_id

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 338: (select probability_list_id from pa_project_types where

334: select probability_member_id
335: into x_probability_member_id
336: from pa_probability_members
337: where probability_list_id =
338: (select probability_list_id from pa_project_types where
339: project_type = p_project_type)
340: and probability_percentage = p_probability_percentage;
341: else -- Added the else block for Bug#3807805
342: select probability_member_id

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 1014: FROM pa_project_types

1010: CURSOR l_project_type_csr
1011: (l_project_type VARCHAR2)
1012: IS
1013: SELECT project_type_class_code
1014: FROM pa_project_types
1015: WHERE project_type = l_project_type;
1016:
1017: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1018: BEGIN

Line 1017: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

1013: SELECT project_type_class_code
1014: FROM pa_project_types
1015: WHERE project_type = l_project_type;
1016:
1017: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1018: BEGIN
1019: x_return_status := 'S';
1020: OPEN l_project_type_csr(p_project_type);
1021: FETCH l_project_type_csr INTO l_project_type_class_code;

Line 1400: PA_PROJECT_TYPES_ALL ppta

1396: IS
1397: SELECT 1
1398: FROM PA_VALID_CATEGORIES vc,
1399: PA_PROJECTS_ALL ppa,
1400: PA_PROJECT_TYPES_ALL ppta
1401: WHERE vc.mandatory_flag = 'Y'
1402: AND vc.class_category = c_class_category
1403: AND ppa.project_id = p_object_id
1404: AND ppa.project_type = ppta.project_type

Line 1679: PA_PROJECT_TYPES_ALL ppta

1675: IS
1676: SELECT total_100_percent_flag
1677: FROM PA_VALID_CATEGORIES_V vc,
1678: PA_PROJECTS_ALL ppa,
1679: PA_PROJECT_TYPES_ALL ppta
1680: WHERE ppa.project_id = p_object_id
1681: AND ppa.project_type = ppta.project_type
1682: AND nvl(ppa.org_id, -99) = nvl(ppta.org_id, -99)
1683: AND vc.object_type_id = ppta.project_type_id

Line 1749: FROM PA_PROJECT_TYPES_ALL ppta,

1745: IS
1746: CURSOR C1
1747: IS
1748: SELECT ppta.project_type_id
1749: FROM PA_PROJECT_TYPES_ALL ppta,
1750: PA_PROJECTS_ALL ppa
1751: WHERE ppa.project_id = p_object_id
1752: AND ppa.project_type = ppta.project_type
1753: AND ppa.org_id = ppta.org_id; --MOAC Changes: Bug 4363092: removed nvl usage with org_id

Line 2241: FROM pa_project_types_all pta

2237: SELECT mandatory_flag
2238: FROM pa_valid_categories pvc
2239: WHERE class_category = p_class_category
2240: AND EXISTS (SELECT 'X'
2241: FROM pa_project_types_all pta
2242: WHERE pta.project_type_id = pvc.object_type_id
2243: AND EXISTS (SELECT 'X'
2244: FROM pa_projects_all ppa
2245: WHERE pta.project_type = ppa.project_type