DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on PA_PWP_LINKED_INVOICES

Line 697: Select draft_invoice_num, 'M' link_type From PA_PWP_LINKED_INVOICES PWP

693:
694: -- Cursor C4 is to identify the Manually/Automatically linked draft invoices to a supplier invoice.
695: Cursor C4(P_Invoice_Id Number, P_Project_Id Number) Is
696: Select distinct draft_invoice_num,link_type From (
697: Select draft_invoice_num, 'M' link_type From PA_PWP_LINKED_INVOICES PWP
698: Where PWP.AP_INVOICE_ID = p_invoice_id
699: And PWP.PROJECT_ID = p_project_id
700: UNION ALL
701: Select pdii.draft_invoice_num, 'A' From PA_DRAFT_INVOICE_ITEMS PDII ,

Line 722: Select AP_Invoice_Id Invoice_Id From PA_PWP_LINKED_INVOICES PWP

718:
719: --Cursor C6 is to get all the linked invoices for a given Draft_Inv_Num
720: Cursor C6(P_Draft_Inv_Num Number) IS
721: Select distinct Invoice_Id From (
722: Select AP_Invoice_Id Invoice_Id From PA_PWP_LINKED_INVOICES PWP
723: Where PWP.draft_invoice_num = P_Draft_Inv_Num
724: And PWP.PROJECT_ID = p_project_id
725: And ap_Invoice_Id is not null
726: UNION ALL