APPS.PA_EVENT_CORE dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 881: FROM pa_summary_project_fundings

877:
878: CURSOR proj_rev_bill_amount
879: IS
880: SELECT SUM(NVL(projfunc_accrued_amount,0)),SUM(NVL(projfunc_billed_amount,0))
881: FROM pa_summary_project_fundings
882: WHERE project_id= P_project_id
883: AND task_id IS NULL;
884:
885: CURSOR task_rev_bill_amount

Line 888: FROM pa_summary_project_fundings

884:
885: CURSOR task_rev_bill_amount
886: IS
887: SELECT SUM(NVL(projfunc_accrued_amount,0)),SUM(NVL(projfunc_billed_amount,0))
888: FROM pa_summary_project_fundings
889: WHERE project_id= P_project_id
890: AND task_id=P_task_id;
891: /*This is commented for performance reason*/
892: /* CURSOR PROJ_WRITE_OFF_AMOUNT

Line 1201: Pa_summary_project_fundings fun

1197: SELECT AG.AGREEMENT_ID
1198: FROM pa_projects_all p,
1199: pa_agreements_all ag,
1200: hz_cust_accounts cust,
1201: Pa_summary_project_fundings fun
1202: WHERE p.project_id = P_project_id
1203: AND nvl(p.date_eff_funds_consumption, 'N') = 'Y'
1204: AND fun.project_id = p.project_id
1205: AND ag.agreement_id = fun.agreement_id