APPS.PA_BILLING dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 954: FROM pa_summary_project_fundings pf

950: | Cursor For Selecting record having 0 accrued revenue |
951: --------------------------------------------------------------------------*/
952: CURSOR spf_acc_0 is
953: SELECT pf.agreement_id, pf.project_id, pf.task_id
954: FROM pa_summary_project_fundings pf
955: WHERE (pf.revproc_accrued_amount <> 0 /* MCB related changes */
956: /* The following added to fix bug 2249216 */
957: OR pf.PROJFUNC_ACCRUED_AMOUNT <> 0
958: OR pf.PROJECT_ACCRUED_AMOUNT <> 0

Line 985: pa_summary_project_fundings pf,

981: sum(dri.project_revenue_amount) dri_project_amount,dri.project_currency_code,
982: sum(dri.funding_revenue_amount) dri_funding_amount,dri.funding_currency_code
983: FROM pa_draft_revenue_items dri,
984: pa_draft_revenues dr,
985: pa_summary_project_fundings pf,
986: pa_projects p /* Added pa_projects for bug 3647592 */
987: WHERE dri.project_id = dr.project_id
988: AND dri.draft_revenue_num = dr.draft_revenue_num
989: AND ( (nvl(pf.task_id,0) = 0 AND nvl(p.project_level_funding_flag,'N')='Y')

Line 1007: FROM pa_summary_project_fundings pf

1003: | Cursor For Selecting record having 0 billed amount |
1004: --------------------------------------------------------------------------*/
1005: CURSOR spf_bill_0 is
1006: SELECT pf.agreement_id, pf.project_id, pf.task_id
1007: FROM pa_summary_project_fundings pf
1008: WHERE (pf.invproc_billed_amount <> 0 /* MCB related changes */
1009: /* The following added to fix bug 2249216 */
1010: OR pf.PROJFUNC_BILLED_AMOUNT <> 0
1011: OR pf.PROJECT_BILLED_AMOUNT <> 0

Line 1039: pa_summary_project_fundings pf

1035: sum(dii.project_bill_amount) dii_project_amount,dii.project_currency_code,
1036: sum(dii.funding_bill_amount) dii_funding_amount,dii.funding_currency_code
1037: FROM pa_draft_invoice_items dii,
1038: pa_draft_invoices di,
1039: pa_summary_project_fundings pf
1040: WHERE dii.project_id = di.project_id
1041: AND dii.draft_invoice_num = di.draft_invoice_num
1042: AND dii.invoice_line_type <> 'RETENTION'
1043: AND di.project_id+0 = pf.project_id

Line 1072: pa_summary_project_fundings pf

1068: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -
1069: ( nvl(di.retention_percentage,0)/100 )) ),dii.funding_currency_code) dii_funding_amount,dii.funding_currency_code
1070: FROM pa_draft_invoice_items dii,
1071: pa_draft_invoices di,
1072: pa_summary_project_fundings pf
1073: WHERE dii.project_id = di.project_id /* Bug#5081194 : Removed the +0 for perf issue */
1074: AND dii.draft_invoice_num+0 = di.draft_invoice_num
1075: AND pf.task_id = dii.task_id
1076: AND dii.invoice_line_type <> 'RETENTION'

Line 1143: UPDATE pa_summary_project_fundings pf

1139:
1140: IF g1_debug_mode = 'Y' THEN
1141: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_0 : ');
1142: END IF;
1143: UPDATE pa_summary_project_fundings pf
1144: SET pf.total_accrued_amount = 0,
1145: pf.revproc_accrued_amount = 0, /* MCB related changes */
1146: pf.projfunc_accrued_amount = 0,
1147: pf.project_accrued_amount = 0

Line 1165: UPDATE pa_summary_project_fundings pf

1161:
1162: IF g1_debug_mode = 'Y' THEN
1163: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_amt : ');
1164: END IF;
1165: UPDATE pa_summary_project_fundings pf
1166: SET pf.total_accrued_amount =
1167: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1168: (acc_amt_rec.dri_funding_amount,acc_amt_rec.funding_currency_code),
1169: pf.revproc_accrued_amount =

Line 1200: UPDATE pa_summary_project_fundings pf

1196:
1197: IF g1_debug_mode = 'Y' THEN
1198: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_bill_0 : ');
1199: END IF;
1200: UPDATE pa_summary_project_fundings pf
1201: SET pf.total_billed_amount = 0,
1202: pf.invproc_billed_amount = 0, /* MCB related changes */
1203: pf.projfunc_billed_amount = 0,
1204: pf.project_billed_amount = 0

Line 1222: UPDATE pa_summary_project_fundings pf

1218:
1219: IF g1_debug_mode = 'Y' THEN
1220: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_pl_bill_amt : ');
1221: END IF;
1222: UPDATE pa_summary_project_fundings pf
1223: SET pf.total_billed_amount =
1224: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1225: (pl_bill_amt_rec.dii_funding_amount,pl_bill_amt_rec.funding_currency_code),
1226: pf.invproc_billed_amount =

Line 1254: UPDATE pa_summary_project_fundings pf

1250: IF g1_debug_mode = 'Y' THEN
1251: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_tl_bill_amt : ');
1252: END IF;
1253:
1254: UPDATE pa_summary_project_fundings pf
1255: SET pf.total_billed_amount =
1256: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1257: (tl_bill_amt_rec.dii_funding_amount,tl_bill_amt_rec.funding_currency_code),
1258: pf.invproc_billed_amount =