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 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