APPS.PA_INVOICE_ACTIONS dependencies on PA_PROJECTS

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 451: pa_projects PROJ,

447: 'EXTERNAL-INVOICE'))
448: INTO l_customer_id,l_bill_ship_to_customer_id, l_bill_to, l_ship_to, l_invoice_category
449: FROM pa_draft_invoices INV, pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */
450: pa_project_customers PROJCUST,
451: pa_projects PROJ,
452: pa_project_types PROJTYPE
453: WHERE INV.project_id = P_Project_id
454: AND INV.draft_invoice_num = P_Draft_Invoice_Num
455: AND AGREE.agreement_id = INV.agreement_id

Line 673: pa_projects p,

669: l_dummy := 0;
670: SELECT count(*)
671: INTO l_dummy
672: FROM pa_draft_invoices i,
673: pa_projects p,
674: pa_project_types pt,
675: pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */
676: pa_project_customers PROJCUST
677: WHERE i.ra_invoice_number = l_RA_Invoice_Num

Line 1000: FROM pa_projects p,

996: sum(ii.amount),
997: p.project_currency_code,
998: i.inv_currency_code,
999: sum(ii.inv_amount)
1000: FROM pa_projects p,
1001: pa_draft_invoices i,
1002: pa_draft_invoice_items ii
1003: WHERE p.project_id = i.project_id
1004: AND i.project_id = ii.project_id

Line 1033: FROM pa_projects p,

1029: sum(ii.amount),
1030: p.project_currency_code,
1031: i.inv_currency_code,
1032: sum(ii.inv_amount)
1033: FROM pa_projects p,
1034: pa_draft_invoices i,
1035: pa_draft_invoice_items ii
1036: WHERE p.project_id = i.project_id
1037: AND i.project_id = ii.project_id

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;