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;

Line 1600: FROM pa_projects proj,

1596: l_overapplication_flag VARCHAR2(1) := 'N';
1597:
1598: CURSOR get_intercompany_flag_csr IS
1599: SELECT NVL(ptype.cc_prvdr_flag, 'N')
1600: FROM pa_projects proj,
1601: pa_project_types ptype
1602: WHERE proj.PROJECT_ID = p_project_id
1603: AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE;
1604:

Line 1619: pa_projects PROJ

1615: PROJ.Carrying_Out_Organization_ID
1616: FROM pa_implementations IMP,
1617: fnd_languages BASELANG,
1618: pa_draft_invoices_all INV,
1619: pa_projects PROJ
1620: WHERE INV.project_id = p_project_id
1621: AND INV.draft_invoice_num = p_draft_invoice_num
1622: AND BASELANG.installed_flag = 'B'
1623: AND PROJ.project_id = p_project_id;

Line 1628: l_carry_out_org_id pa_projects.Carrying_Out_Organization_ID%TYPE;

1624: l_business_group_id pa_implementations.business_group_id%TYPE;
1625: l_org_st_ver_id pa_implementations.proj_org_structure_version_id%TYPE;
1626: l_base_language fnd_languages.language_code%TYPE;
1627: l_invoice_date pa_draft_invoices_all.invoice_date%TYPE;
1628: l_carry_out_org_id pa_projects.Carrying_Out_Organization_ID%TYPE;
1629:
1630: x_trx_type VARCHAR2(10);
1631: x_cm_trx_type VARCHAR2(10);
1632: x_error_status NUMBER;