APPS.PA_PWP_INVOICE_REL dependencies on PA_IMPLEMENTATIONS

Line 91: PA_IMPLEMENTATIONS PI

87: AND rac.interface_header_attribute1 = prj.segment1
88: AND rac.interface_header_attribute2 = TO_CHAR ( pdi.draft_invoice_num ) ---- Modified the exists clause for bug#12404156
89: AND rac.interface_header_context = ( SELECT NAME
90: FROM RA_BATCH_SOURCES RBS ,
91: PA_IMPLEMENTATIONS PI
92: WHERE PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID )))
93:
94: UNION
95: -- To pickup manual links

Line 128: PA_IMPLEMENTATIONS PI

124: AND rac.interface_header_attribute1 = prj.segment1
125: AND rac.interface_header_attribute2 = TO_CHAR ( pdi.draft_invoice_num ) ---- Modified the exists clause for bug#12404156
126: AND rac.interface_header_context = ( SELECT NAME
127: FROM RA_BATCH_SOURCES RBS ,
128: PA_IMPLEMENTATIONS PI
129: WHERE PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID )))
130: ;
131:
132:

Line 180: ,PA_IMPLEMENTATIONS PI

176: AND rac.interface_header_attribute2 = TO_CHAR(pdi.draft_invoice_num)
177: AND rac.interface_header_context = ( SELECT NAME
178: FROM
179: RA_BATCH_SOURCES RBS
180: ,PA_IMPLEMENTATIONS PI
181: WHERE
182: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
183: ) --Bug 8204634
184: AND ((rec_date_from IS NULL AND rec_date_to IS NULL ) OR --Bug 8294296

Line 303: FROM pa_implementations;

299: --process the parameters
300: G_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
301: SELECT org_id
302: INTO G_ORG_ID
303: FROM pa_implementations;
304:
305: select fnd_global.user_id into l_user_id from dual;
306: select sysdate into l_date from dual;
307:

Line 785: ,PA_IMPLEMENTATIONS PI

781: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDII.DRAFT_INVOICE_NUM)
782: AND RAC.INTERFACE_HEADER_CONTEXT = ( SELECT NAME
783: FROM
784: RA_BATCH_SOURCES RBS
785: ,PA_IMPLEMENTATIONS PI
786: WHERE
787: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
788: ) --Bug 8204634
789: ) )

Line 816: ,PA_IMPLEMENTATIONS PI

812: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDI.DRAFT_INVOICE_NUM)
813: AND RAC.INTERFACE_HEADER_CONTEXT = ( SELECT NAME
814: FROM
815: RA_BATCH_SOURCES RBS
816: ,PA_IMPLEMENTATIONS PI
817: WHERE
818: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
819: )--Bug 8204634
820: ) ) )