eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 1017: FROM pa_summary_project_fundings pf

1013: | Cursor For Selecting record having 0 accrued revenue |
1014: --------------------------------------------------------------------------*/
1015: CURSOR spf_acc_0 is
1016: SELECT pf.agreement_id, pf.project_id, pf.task_id
1017: FROM pa_summary_project_fundings pf
1018: WHERE (pf.revproc_accrued_amount <> 0 /* MCB related changes */
1019: /* The following added to fix bug 2249216 */
1020: OR pf.PROJFUNC_ACCRUED_AMOUNT <> 0
1021: OR pf.PROJECT_ACCRUED_AMOUNT <> 0

Line 1048: pa_summary_project_fundings pf,

1044: sum(dri.project_revenue_amount) dri_project_amount,dri.project_currency_code,
1045: sum(dri.funding_revenue_amount) dri_funding_amount,dri.funding_currency_code
1046: FROM pa_draft_revenue_items dri,
1047: pa_draft_revenues dr,
1048: pa_summary_project_fundings pf,
1049: pa_projects p /* Added pa_projects for bug 3647592 */
1050: WHERE dri.project_id = dr.project_id
1051: AND dri.draft_revenue_num = dr.draft_revenue_num
1052: AND ( (nvl(pf.task_id,0) = 0 AND nvl(p.project_level_funding_flag,'N')='Y')

Line 1070: FROM pa_summary_project_fundings pf

1066: | Cursor For Selecting record having 0 billed amount |
1067: --------------------------------------------------------------------------*/
1068: CURSOR spf_bill_0 is
1069: SELECT pf.agreement_id, pf.project_id, pf.task_id
1070: FROM pa_summary_project_fundings pf
1071: WHERE (pf.invproc_billed_amount <> 0 /* MCB related changes */
1072: /* The following added to fix bug 2249216 */
1073: OR pf.PROJFUNC_BILLED_AMOUNT <> 0
1074: OR pf.PROJECT_BILLED_AMOUNT <> 0

Line 1102: pa_summary_project_fundings pf

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'
1106: AND di.project_id+0 = pf.project_id

Line 1138: pa_summary_project_fundings pf

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
1142: AND dii.invoice_line_type <> 'RETENTION'

Line 1212: UPDATE pa_summary_project_fundings pf

1208:
1209: IF g1_debug_mode = 'Y' THEN
1210: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_0 : ');
1211: END IF;
1212: UPDATE pa_summary_project_fundings pf
1213: SET pf.total_accrued_amount = 0,
1214: pf.revproc_accrued_amount = 0, /* MCB related changes */
1215: pf.projfunc_accrued_amount = 0,
1216: pf.project_accrued_amount = 0

Line 1234: UPDATE pa_summary_project_fundings pf

1230:
1231: IF g1_debug_mode = 'Y' THEN
1232: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_amt : ');
1233: END IF;
1234: UPDATE pa_summary_project_fundings pf
1235: SET pf.total_accrued_amount =
1236: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1237: (acc_amt_rec.dri_funding_amount,acc_amt_rec.funding_currency_code),
1238: pf.revproc_accrued_amount =

Line 1269: UPDATE pa_summary_project_fundings pf

1265:
1266: IF g1_debug_mode = 'Y' THEN
1267: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_bill_0 : ');
1268: END IF;
1269: UPDATE pa_summary_project_fundings pf
1270: SET pf.total_billed_amount = 0,
1271: pf.invproc_billed_amount = 0, /* MCB related changes */
1272: pf.projfunc_billed_amount = 0,
1273: pf.project_billed_amount = 0

Line 1291: UPDATE pa_summary_project_fundings pf

1287:
1288: IF g1_debug_mode = 'Y' THEN
1289: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_pl_bill_amt : ');
1290: END IF;
1291: UPDATE pa_summary_project_fundings pf
1292: SET pf.total_billed_amount =
1293: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1294: (pl_bill_amt_rec.dii_funding_amount,pl_bill_amt_rec.funding_currency_code),
1295: pf.invproc_billed_amount =

Line 1324: UPDATE pa_summary_project_fundings pf

1320: IF g1_debug_mode = 'Y' THEN
1321: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_tl_bill_amt : ');
1322: END IF;
1323:
1324: UPDATE pa_summary_project_fundings pf
1325: SET pf.total_billed_amount =
1326: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1327: (tl_bill_amt_rec.dii_funding_amount,tl_bill_amt_rec.funding_currency_code),
1328: pf.invproc_billed_amount =

Line 2226: Pa_Summary_Project_Fundings pf,

2222: pf.GLOBAL_ATTRIBUTE27,pf.GLOBAL_ATTRIBUTE28,
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

Line 2262: Pa_Summary_Project_Fundings pf,

2258: pf.GLOBAL_ATTRIBUTE27,pf.GLOBAL_ATTRIBUTE28,
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