APPS.PA_PROJECT_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 135: from pa_project_types_all t, pa_projects_all p -- Modified pa_projects and pa_project_types to pa_projects_all and pa_project_types_all for bug#3512486

131: where project_type = x_project_type;
132:
133: cursor c2 is
134: select project_type_class_code
135: from pa_project_types_all t, pa_projects_all p -- Modified pa_projects and pa_project_types to pa_projects_all and pa_project_types_all for bug#3512486
136: where p.project_id = x_project_id
137: and p.project_type = t.project_type
138: -- and nvl(p.org_id, -99) = nvl(t.org_id, -99); -- Added the and condition for bug#3512486
139: and p.org_id = t.org_id ;

Line 627: PA_PROJECT_TYPES_ALL PPTA

623: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
624: */
625: FROM PA_VALID_CATEGORIES_V VC,
626: PA_PROJECTS_ALL PPA,
627: PA_PROJECT_TYPES_ALL PPTA
628: WHERE VC.MANDATORY_FLAG = 'Y'
629: AND PPA.PROJECT_ID = x_project_id
630: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE
631: --AND nvl(PPA.ORG_ID, -99) = nvl(PPTA.ORG_ID, -99)

Line 1882: FROM pa_project_types_all pt,

1878:
1879: BEGIN
1880:
1881: SELECT administrative_flag INTO l_admin_flag
1882: FROM pa_project_types_all pt,
1883: pa_projects_all proj
1884: WHERE pt.project_type = proj.project_type
1885: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1886: AND pt.org_id = proj.org_id --avajain

Line 1917: FROM pa_project_types_all pt,

1913:
1914: BEGIN
1915:
1916: SELECT pt.unassigned_time INTO l_unassigned_time_flag
1917: FROM pa_project_types_all pt,
1918: pa_projects_all proj
1919: WHERE pt.project_type = proj.project_type
1920: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1921: AND pt.org_id = proj.org_id