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 133: PA_PROJECTS_ALL PPA,

129: CURSOR C1
130: IS
131: SELECT NULL
132: FROM PA_VALID_CATEGORIES_V VC,
133: PA_PROJECTS_ALL PPA,
134: PA_PROJECT_TYPES_ALL PPTA
135: WHERE VC.MANDATORY_FLAG = 'Y'
136: AND PPA.PROJECT_ID = x_project_id
137: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE

Line 156: PA_PROJECTS_ALL PPA

152: SELECT 1
153: FROM PA_CLASS_CATEGORIES cc,
154: PA_VALID_CATEGORIES vc,
155: PA_PROJECT_TYPES_ALL PPTA,
156: PA_PROJECTS_ALL PPA
157: WHERE VC.CLASS_CATEGORY = CC.CLASS_CATEGORY
158: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
159: AND TRUNC(NVL(CC.END_DATE_ACTIVE, SYSDATE))
160: AND VC.OBJECT_TYPE_ID = PPTA.PROJECT_TYPE_ID

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

279: km_start_date DATE;
280: km_end_date DATE;
281: l_dummy NUMBER := 0;
282: CURSOR c1 IS
283: SELECT NVL(Start_Date,trunc(Sysdate)) FROM Pa_Projects_all -- Bug#3807805 : Modified Pa_Projects to Pa_Projects_all
284: WHERE PROJECT_ID = x_project_id;
285:
286: /* Added the following cursor instead of select statement to
287: handle the "too many rows selected" condition.