APPS.PA_PWP_INVOICE_REL dependencies on PA_IMPLEMENTATIONS

Line 74: ,PA_IMPLEMENTATIONS PI

70: AND rac.interface_header_attribute2 = TO_CHAR(pdi.draft_invoice_num)
71: AND rac.interface_header_context = ( SELECT NAME
72: FROM
73: RA_BATCH_SOURCES RBS
74: ,PA_IMPLEMENTATIONS PI
75: WHERE
76: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
77: ) --Bug 8204634
78: AND PDII.project_id = crdl.project_id

Line 120: ,PA_IMPLEMENTATIONS PI

116: AND rac.interface_header_attribute2 = TO_CHAR(pdi.draft_invoice_num)
117: AND rac.interface_header_context = ( SELECT NAME
118: FROM
119: RA_BATCH_SOURCES RBS
120: ,PA_IMPLEMENTATIONS PI
121: WHERE
122: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
123: ) --Bug 8204634
124: AND EXISTS -- atleast one reciept applied between rec start and end date params

Line 187: ,PA_IMPLEMENTATIONS PI

183: AND rac.interface_header_attribute2 = TO_CHAR(pdi.draft_invoice_num)
184: AND rac.interface_header_context = ( SELECT NAME
185: FROM
186: RA_BATCH_SOURCES RBS
187: ,PA_IMPLEMENTATIONS PI
188: WHERE
189: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
190: ) --Bug 8204634
191: AND EXISTS -- atleast one reciept applied between rec start and end date params

Line 302: FROM pa_implementations;

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

Line 779: ,PA_IMPLEMENTATIONS PI

775: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDII.DRAFT_INVOICE_NUM)
776: AND RAC.INTERFACE_HEADER_CONTEXT = ( SELECT NAME
777: FROM
778: RA_BATCH_SOURCES RBS
779: ,PA_IMPLEMENTATIONS PI
780: WHERE
781: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
782: ) --Bug 8204634
783: ) )

Line 808: ,PA_IMPLEMENTATIONS PI

804: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDI.DRAFT_INVOICE_NUM)
805: AND RAC.INTERFACE_HEADER_CONTEXT = ( SELECT NAME
806: FROM
807: RA_BATCH_SOURCES RBS
808: ,PA_IMPLEMENTATIONS PI
809: WHERE
810: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
811: )--Bug 8204634
812: ) ) )