APPS.PA_EVENT_CORE dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 861: FROM pa_summary_project_fundings

857:
858: CURSOR proj_rev_bill_amount
859: IS
860: SELECT SUM(NVL(projfunc_accrued_amount,0)),SUM(NVL(projfunc_billed_amount,0))
861: FROM pa_summary_project_fundings
862: WHERE project_id= P_project_id
863: AND task_id IS NULL;
864:
865: CURSOR task_rev_bill_amount

Line 868: FROM pa_summary_project_fundings

864:
865: CURSOR task_rev_bill_amount
866: IS
867: SELECT SUM(NVL(projfunc_accrued_amount,0)),SUM(NVL(projfunc_billed_amount,0))
868: FROM pa_summary_project_fundings
869: WHERE project_id= P_project_id
870: AND task_id=P_task_id;
871: /*This is commented for performance reason*/
872: /* CURSOR PROJ_WRITE_OFF_AMOUNT

Line 1180: Pa_summary_project_fundings fun

1176: SELECT AG.AGREEMENT_ID
1177: FROM pa_projects_all p,
1178: pa_agreements_all ag,
1179: hz_cust_accounts cust,
1180: Pa_summary_project_fundings fun
1181: WHERE p.project_id = P_project_id
1182: AND nvl(p.date_eff_funds_consumption, 'N') = 'Y'
1183: AND fun.project_id = p.project_id
1184: AND ag.agreement_id = fun.agreement_id