APPS.PA_BILLING_PROCESS_PKG dependencies on PA_SUMMARY_PROJECT_FUNDINGS

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

49: )
50: ); commented for bug 8813330*/
51:
52: CURSOR cspf(cproject_id VARCHAR2) is
53: SELECT /*+ INDEX(pf pa_summary_project_fundings_u1)*/ 1
54: FROM pa_summary_project_fundings spf
55: WHERE spf.project_id = cproject_id
56: AND nvl(spf.revproc_baselined_amount, 0) <> 0;
57:

Line 54: FROM pa_summary_project_fundings spf

50: ); commented for bug 8813330*/
51:
52: CURSOR cspf(cproject_id VARCHAR2) is
53: SELECT /*+ INDEX(pf pa_summary_project_fundings_u1)*/ 1
54: FROM pa_summary_project_fundings spf
55: WHERE spf.project_id = cproject_id
56: AND nvl(spf.revproc_baselined_amount, 0) <> 0;
57:
58:

Line 102: ' pa_summary_project_fundings spf '||

98: END IF;
99:
100: IF G_Agrmnt_ID <> 0 THEN
101: v_inv_query5 := 'AND EXISTS ( SELECT NULL FROM pa_agreements_all agr, '||
102: ' pa_summary_project_fundings spf '||
103: ' WHERE agr.agreement_id = spf.agreement_id '||
104: ' AND spf.project_id = p.project_id '||
105: ' AND nvl(spf.total_baselined_amount, 0) > 0 '||
106: ' AND agr.agreement_id = ' ||g_agrmnt_id||