DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on PA_EXPENDITURE_ITEMS

Line 851: PA_EXPENDITURE_ITEMS EI

847: And PWP.PROJECT_ID = p_project_id
848: UNION ALL
849: Select pdii.draft_invoice_num, 'A' From PA_DRAFT_INVOICE_ITEMS PDII ,
850: PA_CUST_REV_DIST_LINES CRDL ,
851: PA_EXPENDITURE_ITEMS EI
852: Where PDII.project_id = crdl.project_id
853: And pdii.draft_invoice_num = crdl.draft_invoice_num
854: And pdii.line_num = crdl.draft_invoice_item_line_num
855: And crdl.expenditure_item_id = ei.expenditure_item_id

Line 877: PA_EXPENDITURE_ITEMS EI

873: And ap_Invoice_Id is not null
874: UNION ALL
875: Select ei.document_header_id From PA_DRAFT_INVOICE_ITEMS PDII ,
876: PA_CUST_REV_DIST_LINES CRDL ,
877: PA_EXPENDITURE_ITEMS EI
878: Where PDII.project_id = crdl.project_id
879: And pdii.draft_invoice_num = P_Draft_Inv_Num
880: AND pdii.draft_invoice_num = crdl.draft_invoice_num
881: And pdii.line_num = crdl.draft_invoice_item_line_num