APPS.PA_BILLING dependencies on PA_DRAFT_INVOICE_ITEMS

Line 92: in ( select /*+ INDEX(i PA_DRAFT_INVOICE_ITEMS_N2)*/ SUM(i.bill_trans_bill_amount)

88: e.bill_trans_bill_amount)
89: from pa_event_types et
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

Line 93: from pa_draft_invoice_items i ,

89: from pa_event_types et
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

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 1080: FROM pa_draft_invoice_items dii,

1076: /* END fix bug 2249216 */
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

Line 1100: FROM pa_draft_invoice_items dii,

1096: sum(dii.amount) dii_amount,dii.invproc_currency_code,
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

Line 1136: FROM pa_draft_invoice_items dii,

1132: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
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

Line 2227: Pa_Draft_Invoice_items dii,

2223: pf.GLOBAL_ATTRIBUTE29,pf.GLOBAL_ATTRIBUTE30,
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

Line 2263: Pa_Draft_Invoice_items dii,

2259: pf.GLOBAL_ATTRIBUTE29,pf.GLOBAL_ATTRIBUTE30,
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

Line 2322: update Pa_Draft_Invoice_items dii

2318:
2319: IF g1_debug_mode = 'Y' THEN
2320: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_proj_level : ');
2321: END IF;
2322: update Pa_Draft_Invoice_items dii
2323: set dii.global_attribute_category = rec_prjlvl.global_attribute_category,
2324: dii.GLOBAL_ATTRIBUTE1 = rec_prjlvl.GLOBAL_ATTRIBUTE1,
2325: dii.GLOBAL_ATTRIBUTE2 = rec_prjlvl.GLOBAL_ATTRIBUTE2,
2326: dii.GLOBAL_ATTRIBUTE3 = rec_prjlvl.GLOBAL_ATTRIBUTE3,

Line 2364: update Pa_Draft_Invoice_items dii

2360:
2361: IF g1_debug_mode = 'Y' THEN
2362: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_task_level : ');
2363: END IF;
2364: update Pa_Draft_Invoice_items dii
2365: set
2366: dii.global_attribute_category = rec_tasklvl.global_attribute_category,
2367: dii.GLOBAL_ATTRIBUTE1 = rec_tasklvl.GLOBAL_ATTRIBUTE1,
2368: dii.GLOBAL_ATTRIBUTE2 = rec_tasklvl.GLOBAL_ATTRIBUTE2,