APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_PROJECTS_ALL

Line 12: FROM pa_projects_all

8: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9: x_err_msgname IN OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
10: CURSOR get_top_task_cust_enbled IS
11: SELECT enable_top_task_customer_flag
12: FROM pa_projects_all
13: WHERE project_id = x_project_id;
14: l_en_top_task_cust_flag VARCHAR2(1);
15:
16: --added the below code for Federal changes by sunkalya

Line 22: pa_projects_all

18: CURSOR get_date_eff_funds_flag
19: IS
20: SELECT nvl(DATE_EFF_FUNDS_CONSUMPTION,'N')
21: FROM
22: pa_projects_all
23: WHERE project_id = x_project_id;
24: l_date_eff_funds_flag VARCHAR2(1);
25:
26: --end of code added for federal changes by sunkalya

Line 125: PA_PROJECTS_ALL PPA,

121: CURSOR C1
122: IS
123: SELECT NULL
124: FROM PA_VALID_CATEGORIES_V VC,
125: PA_PROJECTS_ALL PPA,
126: PA_PROJECT_TYPES_ALL PPTA
127: WHERE VC.MANDATORY_FLAG = 'Y'
128: AND PPA.PROJECT_ID = x_project_id
129: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE

Line 148: PA_PROJECTS_ALL PPA

144: SELECT 1
145: FROM PA_CLASS_CATEGORIES cc,
146: PA_VALID_CATEGORIES vc,
147: PA_PROJECT_TYPES_ALL PPTA,
148: PA_PROJECTS_ALL PPA
149: WHERE VC.CLASS_CATEGORY = CC.CLASS_CATEGORY
150: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
151: AND TRUNC(NVL(CC.END_DATE_ACTIVE, SYSDATE))
152: AND VC.OBJECT_TYPE_ID = PPTA.PROJECT_TYPE_ID

Line 275: SELECT NVL(Start_Date,trunc(Sysdate)) FROM Pa_Projects_all -- Bug#3807805 : Modified Pa_Projects to Pa_Projects_all

271: km_start_date DATE;
272: km_end_date DATE;
273: l_dummy NUMBER := 0;
274: CURSOR c1 IS
275: SELECT NVL(Start_Date,trunc(Sysdate)) FROM Pa_Projects_all -- Bug#3807805 : Modified Pa_Projects to Pa_Projects_all
276: WHERE PROJECT_ID = x_project_id;
277:
278: /* Added the following cursor instead of select statement to
279: handle the "too many rows selected" condition.