APPS.PA_FUND_REVAL_PVT dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 1135: UPDATE pa_summary_project_fundings

1131: DELETE FROM pa_project_fundings
1132: WHERE project_funding_id = l_FundingIdTab(i);
1133:
1134: FORALL i IN l_ProjfuncAllocTab.FIRST..l_ProjfuncAllocTab.LAST
1135: UPDATE pa_summary_project_fundings
1136: SET projfunc_unbaselined_amount =
1137: nvl(projfunc_unbaselined_amount,0) - nvl(l_ProjfuncAllocTab(i),0),
1138: invproc_unbaselined_amount =
1139: nvl(invproc_unbaselined_amount,0) - nvl(l_InvprocAllocTab(i),0),

Line 1724: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC

1720: SPF.projfunc_accrued_amount projfunc_accrued_amount,
1721: SPF.invproc_billed_amount invproc_billed_amount,
1722: PC.retention_level_code retention_level_code,
1723: PC.customer_id customer_id
1724: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC
1725: WHERE SPF.project_id = l_ProjectId
1726: AND A.agreement_id = SPF.agreement_id
1727: AND PC.customer_id = A.customer_id
1728: AND PC.project_id = SPF.project_id

Line 1757: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC

1753: SPF.projfunc_accrued_amount projfunc_accrued_amount,
1754: SPF.invproc_billed_amount invproc_billed_amount,
1755: PC.retention_level_code retention_level_code,
1756: PC.customer_id cust_id
1757: FROM pa_summary_project_fundings SPF, pa_agreements_all A, pa_project_customers PC
1758: WHERE SPF.project_id = l_ProjectId
1759: AND A.agreement_id = SPF.agreement_id
1760: AND PC.customer_id = A.customer_id
1761: AND PC.project_id = SPF.project_id

Line 1780: FROM pa_mc_sum_proj_fundings SPF_mc, pa_summary_project_fundings SPF,

1776: SPF_mc.total_accrued_amount projfunc_accrued_amount,
1777: SPF.invproc_billed_amount invproc_billed_amount,
1778: PC.retention_level_code retention_level_code,
1779: PC.customer_id cust_id
1780: FROM pa_mc_sum_proj_fundings SPF_mc, pa_summary_project_fundings SPF,
1781: pa_agreements_all A, pa_project_customers PC,
1782: gl_alc_ledger_rships_v rep, pa_implementations imp
1783: WHERE SPF.project_id = l_ProjectId
1784: AND A.agreement_id = SPF.agreement_id

Line 9104: UPDATE pa_summary_project_fundings

9100: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9101:
9102: END IF;
9103:
9104: UPDATE pa_summary_project_fundings
9105: SET reval_rejection_code = p_reason_code,
9106: last_update_date = sysdate,
9107: last_updated_by = G_LAST_UPDATED_BY,
9108: last_update_login = G_LAST_UPDATE_LOGIN,

Line 9354: UPDATE pa_summary_project_fundings

9350: PA_FUND_REVAL_UTIL.Log_Message(l_LogMsg);
9351:
9352: END IF;
9353:
9354: UPDATE pa_summary_project_fundings
9355: SET projfunc_unbaselined_amount =
9356: nvl(projfunc_unbaselined_amount,0) + G_RevalCompTab(l_SobId).projfunc_allocated_amount,
9357: revproc_unbaselined_amount =
9358: nvl(revproc_unbaselined_amount,0) + G_RevalCompTab(l_SobId).projfunc_allocated_amount,