APPS.PA_BILL_WORKBENCH_INVOICE dependencies on PA_PROJECTS_ALL

Line 64: FROM pa_projects_all

60: SELECT nvl(multi_currency_billing_flag, 'N'),
61: nvl(org_id, -99)
62: INTO x_mcb_flag,
63: x_org_id
64: FROM pa_projects_all
65: WHERE project_id = p_project_id;
66:
67:
68: /* ------------------------------------------------------------

Line 436: pa_projects_all p /* added the refrence to pa_projects_all for project_status_code */

432:
433: SELECT i.customer_id, i.generation_error_flag,
434: i.approved_date , p.project_status_code
435: FROM pa_draft_invoices_all i, /* changed the refrence to base table instead of pa_draft_invoices_all_v for bug # 4666256 */
436: pa_projects_all p /* added the refrence to pa_projects_all for project_status_code */
437: WHERE i.project_id = P_Project_ID
438: AND p.project_id = i.project_id
439: AND i.draft_invoice_num = P_Draft_Invoice_Num;
440: