APPS.PA_INVOICE_ACTIONS dependencies on PA_PROJECTS_ALL

Line 294: pa_projects_all prj

290: Cursor Inv_cur is
291: SELECT i.customer_id, i.generation_error_flag,
292: i.approved_date, prj.project_status_code project_status_code
293: FROM pa_draft_invoices i,
294: pa_projects_all prj
295: WHERE prj.project_id = P_Project_ID
296: AND i.project_id = prj.project_id
297: AND i.draft_invoice_num = P_Draft_Invoice_Num;
298:

Line 1116: FROM PA_Projects_ALL

1112: /* Lock The Project */
1113: IF (l_project_id <> l_prv_project_id) THEN
1114: SELECT Project_ID
1115: INTO l_dummy
1116: FROM PA_Projects_ALL
1117: WHERE Project_ID = l_project_id
1118: FOR UPDATE OF LAST_UPDATE_DATE;
1119:
1120: l_prv_project_id := l_project_id;

Line 1250: FROM PA_Projects_ALL

1246: /* Lock The Project */
1247: IF (l_project_id <> l_prv_project_id) THEN
1248: SELECT Project_ID
1249: INTO l_dummy
1250: FROM PA_Projects_ALL
1251: WHERE Project_ID = l_project_id
1252: FOR UPDATE OF LAST_UPDATE_DATE;
1253:
1254: l_prv_project_id := l_project_id;