APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_PROJECT_TYPES_ALL

Line 613: From pa_projects_all pa, pa_project_types_all pt

609:
610: CURSOR l_project_csr (c_project_id NUMBER) -- Bug 6166197: cursor modified to fetch project_type_class_code also
611: Is
612: Select project_currency_code, project_type_class_code
613: From pa_projects_all pa, pa_project_types_all pt
614: Where pa.project_id = c_project_id
615: And pa.project_type = pt.project_type
616: And nvl(pa.org_id,-99) = nvl(pt.org_id,-99);
617:

Line 671: l_proj_type_class_code pa_project_types_all.project_type_class_code%TYPE; -- Bug 6166197

667: l_ship_to_customer_id Number;
668:
669: --customer Account Relationship changes
670:
671: l_proj_type_class_code pa_project_types_all.project_type_class_code%TYPE; -- Bug 6166197
672:
673: -- anlee org role changes
674: l_project_party_id NUMBER;
675: l_resource_id NUMBER;

Line 3440: FROM PA_PROJECT_TYPES_ALL ppta,

3436:
3437: if p_object_type = 'PA_PROJECTS' then
3438: SELECT ppta.project_type_id
3439: INTO l_object_type_id
3440: FROM PA_PROJECT_TYPES_ALL ppta,
3441: PA_PROJECTS_ALL ppa
3442: WHERE ppa.project_id = p_object_id
3443: AND ppa.project_type = ppta.project_type
3444: -- AND NVL(ppa.org_id, -99) = NVL(ppta.org_id, -99); MOAC Changes: Bug 4363092 - removed nvl

Line 3559: FROM PA_PROJECT_TYPES_ALL ppta,

3555:
3556: if p_object_type = 'PA_PROJECTS' then
3557: SELECT ppta.project_type_id
3558: INTO l_object_type_id
3559: FROM PA_PROJECT_TYPES_ALL ppta,
3560: PA_PROJECTS_ALL ppa
3561: WHERE ppa.project_id = p_object_id
3562: AND ppa.project_type = ppta.project_type
3563: -- AND NVL(ppa.org_id, -99) = NVL(ppta.org_id, -99); MOAC Changes: Bug 4363092 - removed nvl

Line 4179: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4175: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4176: cursor get_project_type_info (c_project_type VARCHAR2)
4177: IS
4178: select *
4179: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4180: where project_type = c_project_type
4181: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4182: -- anlee end of changes
4183:

Line 4188: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4184: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4185: cursor get_unassigned_time (c_project_type VARCHAR2)
4186: IS
4187: Select unassigned_time
4188: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4189: where project_type = c_project_type
4190: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4191:
4192: l_unassigned_time pa_project_types.unassigned_time%TYPE;

Line 4203: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4199: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4200: cursor get_project_type_class_code (c_project_type VARCHAR2)
4201: IS
4202: Select project_type_class_code
4203: from pa_project_types_all -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4204: where project_type = c_project_type
4205: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4206:
4207: cursor get_billable_cap_flag (c_work_type_id NUMBER)

Line 4963: from pa_project_types_all pt -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all

4959:
4960: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4961: select meaning
4962: into t_project_type_class_code
4963: from pa_project_types_all pt -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4964: , pa_lookups lps
4965: where pt.project_type = p_project_type
4966: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
4967: and lps.lookup_code(+) = pt.project_type_class_code