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_FUND_REVAL_PVT dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 1133: UPDATE pa_summary_project_fundings

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

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

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

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

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

Line 1778: FROM pa_mc_sum_proj_fundings SPF_mc, pa_summary_project_fundings SPF,

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

Line 9071: UPDATE pa_summary_project_fundings

9067: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9068:
9069: END IF;
9070:
9071: UPDATE pa_summary_project_fundings
9072: SET reval_rejection_code = p_reason_code,
9073: last_update_date = sysdate,
9074: last_updated_by = G_LAST_UPDATED_BY,
9075: last_update_login = G_LAST_UPDATE_LOGIN,

Line 9321: UPDATE pa_summary_project_fundings

9317: PA_FUND_REVAL_UTIL.Log_Message(l_LogMsg);
9318:
9319: END IF;
9320:
9321: UPDATE pa_summary_project_fundings
9322: SET projfunc_unbaselined_amount =
9323: nvl(projfunc_unbaselined_amount,0) + G_RevalCompTab(l_SobId).projfunc_allocated_amount,
9324: revproc_unbaselined_amount =
9325: nvl(revproc_unbaselined_amount,0) + G_RevalCompTab(l_SobId).projfunc_allocated_amount,