APPS.PA_AGREEMENT_CORE dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 438: From Pa_Summary_Project_Fundings

434: Select nvl(sum(total_baselined_amount),0),
435: nvl(sum(total_unbaselined_amount),0)
436: into l_tot_baselined_amt,
437: l_tot_unbaselined_amt
438: From Pa_Summary_Project_Fundings
439: where Agreement_id = p_Agreement_id;
440: IF (nvl(p_amount, 0) <
441: nvl(l_tot_unbaselined_amt, 0) +
442: nvl(l_tot_baselined_amt, 0)) THEN

Line 1233: FROM pa_summary_project_fundings f1

1229: /*
1230: SELECT MIN(SIGN((f1.total_baselined_amount+f1.total_unbaselined_amount)
1231: -GREATEST(NVL(f1.total_accrued_amount,0), NVL(f1.total_billed_amount, 0))))
1232: INTO check_limit
1233: FROM pa_summary_project_fundings f1
1234: WHERE f1.agreement_id = p_agreement_id;
1235: */
1236: /* commented and rewritten for bug 2744993
1237: SELECT MIN(SIGN((f1.total_baselined_amount+f1.total_unbaselined_amount)

Line 1243: FROM pa_summary_project_fundings f1

1239: */
1240: SELECT MIN(SIGN((f1.projfunc_baselined_amount+f1.projfunc_unbaselined_amount)
1241: - NVL(f1.projfunc_accrued_amount, 0)))
1242: INTO l_check_limit
1243: FROM pa_summary_project_fundings f1
1244: WHERE f1.agreement_id = p_agreement_id;
1245:
1246: IF l_check_limit < 0 then
1247: -- dbms_output.put_line('Returning N');

Line 1426: FROM pa_summary_project_fundings f1

1422: */
1423: SELECT MIN(SIGN((f1.invproc_baselined_amount+f1.invproc_unbaselined_amount)
1424: - NVL(f1.invproc_billed_amount, 0)))
1425: INTO l_check_limit
1426: FROM pa_summary_project_fundings f1
1427: WHERE f1.agreement_id = p_agreement_id;
1428:
1429: IF l_check_limit < 0 then
1430: -- dbms_output.put_line('Returning N');