APPS.PA_PWP_INVOICE_REL dependencies on PA_DRAFT_INVOICES

Line 58: , pa_draft_invoices pdi

54: ,EI.document_header_id AP_INVOICE_ID
55: ,'AUTOLINK' link_type
56: FROM pa_projects prj
57: , ra_customer_trx rac
58: , pa_draft_invoices pdi
59: , pa_draft_invoice_items pdii
60: , pa_cust_rev_dist_lines crdl
61: , pa_expenditure_items ei
62: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)

Line 107: , pa_draft_invoices pdi

103: , pwp.AP_INVOICE_ID
104: ,'MANUAL' link_type
105: FROM pa_projects prj
106: , ra_customer_trx rac
107: , pa_draft_invoices pdi
108: , pa_pwp_linked_invoices pwp
109: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
110: AND prj.segment1 BETWEEN start_project_num AND end_project_num
111: AND prj.project_id = pdi.project_id

Line 165: , pa_draft_invoices pdi

161: ELSE 'Y'
162: END, 'Y') payment_status
163: FROM pa_projects prj
164: , ra_customer_trx rac
165: , pa_draft_invoices pdi
166: , pa_draft_invoice_items pdii
167: , pa_events pae
168: , pa_event_types pet
169: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)

Line 746: , PA_DRAFT_INVOICES PDI

742: SELECT 1
743: FROM PA_EXPENDITURE_ITEMS EI
744: , PA_CUST_REV_DIST_LINES CRDL
745: , PA_DRAFT_INVOICE_ITEMS PDII
746: , PA_DRAFT_INVOICES PDI
747: , PA_PROJECTS PRJ
748: , PA_TASKS TASK
749: , PA_TASKS TOPTASK
750: WHERE EI.PROJECT_ID = TASK.PROJECT_ID

Line 790: , PA_DRAFT_INVOICES PDI

786: OR exists
787: -- unpaid manually linked invoices exist
788: (SELECT 1
789: FROM PA_PROJECTS PRJ
790: , PA_DRAFT_INVOICES PDI
791: , PA_PWP_LINKED_INVOICES PWP
792: WHERE PRJ.PROJECT_ID = PDI.PROJECT_ID
793: AND PDI.PROJECT_ID = PWP.PROJECT_ID -- Bug 7720228
794: AND PDI.DRAFT_INVOICE_NUM = PWP.DRAFT_INVOICE_NUM