APPS.PA_PROJECT_UTILS dependencies on PA_PROJECT_TYPES

Line 130: from pa_project_types

126: , x_err_stack IN OUT NOCOPY varchar2) --File.Sql.39 bug 4440895
127: is
128: cursor c1 is
129: select project_type_class_code
130: from pa_project_types
131: where project_type = x_project_type;
132:
133: cursor c2 is
134: select project_type_class_code

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 436: select project_type from pa_project_types

432: --
433: function check_project_type_valid (x_project_type IN varchar2 ) return number
434: is
435: cursor c1 is
436: select project_type from pa_project_types
437: where project_type = x_project_type ;
438:
439: c1_rec c1%rowtype;
440:

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 830: cursor p1 is select 1 from pa_project_types

826: old_stack varchar2(630);
827: status_code number;
828: l_return_val varchar2(1);
829: dummy_null varchar2(30) default null;
830: cursor p1 is select 1 from pa_project_types
831: where burden_sum_dest_project_id = x_project_id;
832: temp number;
833: --Ansari
834: x_used_in_OTL BOOLEAN; --To pass to OTL API.

Line 1894: FROM pa_project_types_all pt,

1890:
1891: BEGIN
1892:
1893: SELECT administrative_flag INTO l_admin_flag
1894: FROM pa_project_types_all pt,
1895: pa_projects_all proj
1896: WHERE pt.project_type = proj.project_type
1897: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1898: AND pt.org_id = proj.org_id --avajain

Line 1929: FROM pa_project_types_all pt,

1925:
1926: BEGIN
1927:
1928: SELECT pt.unassigned_time INTO l_unassigned_time_flag
1929: FROM pa_project_types_all pt,
1930: pa_projects_all proj
1931: WHERE pt.project_type = proj.project_type
1932: --AND nvl(pt.org_id, -99) = nvl(proj.org_id, -99)
1933: AND pt.org_id = proj.org_id