APPS.PA_PWP_INVOICE_LINKS dependencies on PA_PWP_LINKED_INVOICES

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

9:
10:
11: Cursor C1(P_Invoice_Id Number, P_Project_Id Number) Is
12: Select distinct draft_invoice_num,link_type From (
13: Select draft_invoice_num, 'M' link_type From PA_PWP_LINKED_INVOICES PWP
14: Where PWP.AP_INVOICE_ID = p_invoice_id
15: And PWP.PROJECT_ID = p_project_id
16: UNION ALL
17: Select pdii.draft_invoice_num, 'A' From PA_DRAFT_INVOICE_ITEMS PDII ,

Line 39: FROM PA_PWP_LINKED_INVOICES

35:
36: --Bug 7650431 Changed the FORALL to normal For Loop.
37: FOR i in PA_LINK_TAB.first..PA_LINK_TAB.last Loop
38: DELETE
39: FROM PA_PWP_LINKED_INVOICES
40: WHERE project_id = PA_LINK_TAB(i).PROJECT_ID
41: AND draft_invoice_num = PA_LINK_TAB(i).DRAFT_INVOICE_NUM
42: AND ap_invoice_id = PA_LINK_TAB(i).AP_INVOICE_ID;
43:

Line 102: INTO PA_PWP_LINKED_INVOICES

98: --Bug 7650431 Changed the FORALL to normal For Loop.
99: FOR i in PA_LINK_TAB.first..PA_LINK_TAB.last Loop
100:
101: INSERT
102: INTO PA_PWP_LINKED_INVOICES
103: ( ORG_ID,
104: PROJECT_ID ,
105: DRAFT_INVOICE_NUM ,
106: AP_INVOICE_ID ,