APPS.PA_BILLING dependencies on PA_DRAFT_INVOICES

Line 94: pa_draft_invoices di

90: where et.event_type = e.event_type
91: )
92: in ( select /*+ INDEX(i PA_DRAFT_INVOICE_ITEMS_N2)*/ SUM(i.bill_trans_bill_amount)
93: from pa_draft_invoice_items i ,
94: pa_draft_invoices di
95: where nvl(i.event_task_id,0) = nvl(e.task_id,0)
96: and i.project_id = e.project_id
97: and i.event_num = e.event_num
98: and di.draft_invoice_num = i.draft_invoice_num

Line 216: (select NULL from pa_draft_invoices pdi

212: ( nvl(be.trx_independent_flag, 'N') = 'Y'
213: or
214: ( x_calling_process in ('Invoice','Both')
215: AND EXISTS
216: (select NULL from pa_draft_invoices pdi
217: where pdi.project_id = x_project_id
218: and pdi.request_id = x_request_id
219: -- and pdi.invoice_line_type <> 'NET ZERO ADJUSTMENT'
220: and (( x_calling_place = 'ADJ'

Line 862: from pa_draft_invoice_items dii, pa_draft_invoices di

858: DELETE FROM PA_EVENTS V
859: WHERE V.Project_ID = X_project_id
860: AND (nvl(V.Task_ID, -1), V.Event_Num) IN
861: (select nvl(dii.Event_Task_ID, -1), dii.Event_Num
862: from pa_draft_invoice_items dii, pa_draft_invoices di
863: where di.Project_ID = X_project_id
864: and di.draft_invoice_num = X_rev_inv_num
865: and dii.Project_ID = di.Project_ID
866: and dii.draft_invoice_num = di.draft_invoice_num

Line 1081: pa_draft_invoices di

1077: AND pf.project_id = l_project_id;
1078: /*AND NOT EXISTS
1079: ( SELECT null
1080: FROM pa_draft_invoice_items dii,
1081: pa_draft_invoices di
1082: WHERE dii.project_id = di.project_id
1083: AND dii.draft_invoice_num = di.draft_invoice_num
1084: AND ( nvl(pf.task_id,0) = 0
1085: OR dii.task_id = pf.task_id )

Line 1101: pa_draft_invoices di,

1097: sum(dii.projfunc_bill_amount) dii_projfunc_amount,dii.projfunc_currency_code,
1098: sum(dii.project_bill_amount) dii_project_amount,dii.project_currency_code,
1099: sum(dii.funding_bill_amount) dii_funding_amount,dii.funding_currency_code
1100: FROM pa_draft_invoice_items dii,
1101: pa_draft_invoices di,
1102: pa_summary_project_fundings pf
1103: WHERE dii.project_id = di.project_id
1104: AND dii.draft_invoice_num = di.draft_invoice_num
1105: AND dii.invoice_line_type <> 'RETENTION'

Line 1137: pa_draft_invoices di,

1133: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1134: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -
1135: ( nvl(di.retention_percentage,0)/100 )) ),dii.funding_currency_code) dii_funding_amount,dii.funding_currency_code
1136: FROM pa_draft_invoice_items dii,
1137: pa_draft_invoices di,
1138: pa_summary_project_fundings pf
1139: WHERE dii.project_id = di.project_id /* Bug#5081194 : Removed the +0 for perf issue */
1140: AND dii.draft_invoice_num+0 = di.draft_invoice_num
1141: AND pf.task_id = dii.task_id

Line 2228: pa_draft_invoices_all di

2224: dii.rowid
2225: From
2226: Pa_Summary_Project_Fundings pf,
2227: Pa_Draft_Invoice_items dii,
2228: pa_draft_invoices_all di
2229: Where
2230: di.agreement_id = pf.agreement_id
2231: And pf.REQUEST_ID = l_request_id
2232: And pf.REQUEST_ID = di.REQUEST_ID

Line 2264: pa_draft_invoices_all di

2260: dii.rowid
2261: From
2262: Pa_Summary_Project_Fundings pf,
2263: Pa_Draft_Invoice_items dii,
2264: pa_draft_invoices_all di
2265: Where
2266: di.agreement_id = pf.agreement_id
2267: And pf.REQUEST_ID = l_request_id
2268: And pf.REQUEST_ID = di.REQUEST_ID