APPS.PA_BILLING_PROCESS_PKG dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 42: SELECT /*+ INDEX(pf pa_summary_project_fundings_u1)*/ 1

38: )
39: );
40:
41: CURSOR cspf(cproject_id VARCHAR2) is
42: SELECT /*+ INDEX(pf pa_summary_project_fundings_u1)*/ 1
43: FROM pa_summary_project_fundings spf
44: WHERE spf.project_id = cproject_id
45: AND nvl(spf.revproc_baselined_amount, 0) <> 0;
46:

Line 43: FROM pa_summary_project_fundings spf

39: );
40:
41: CURSOR cspf(cproject_id VARCHAR2) is
42: SELECT /*+ INDEX(pf pa_summary_project_fundings_u1)*/ 1
43: FROM pa_summary_project_fundings spf
44: WHERE spf.project_id = cproject_id
45: AND nvl(spf.revproc_baselined_amount, 0) <> 0;
46:
47: