APPS.PJI_FM_EXTR dependencies on PA_PROJECT_FUNDINGS

Line 58: ,pa_project_fundings pf

54: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
55: ,pf.rowid ROW_ID
56: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
57: FROM pji_fm_proj_batch_map bat
58: ,pa_project_fundings pf
59: ,pa_agreements_all agr
60: ,pa_project_customers cust
61: WHERE l_extraction_type = 'FULL'
62: AND pf.agreement_id = agr.agreement_id

Line 74: index(pf,PA_PROJECT_FUNDINGS_N2) use_nl(pf)

70: AND pf.date_allocated is not null
71: union all
72: SELECT /*+ ordered
73: full(bat)
74: index(pf,PA_PROJECT_FUNDINGS_N2) use_nl(pf)
75: */
76: p_worker_id WORKER_ID
77: ,nvl(bat.project_org_id, -1) PROJECT_OU_ID
78: ,bat.project_organization_id PROJECT_ORG_ID

Line 90: ,pa_project_fundings pf

86: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
87: ,pf.rowid ROW_ID
88: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
89: FROM pji_fm_proj_batch_map bat
90: ,pa_project_fundings pf
91: ,pa_agreements_all agr
92: ,pa_project_customers cust
93: WHERE l_extraction_type = 'INCREMENTAL'
94: AND pf.agreement_id = agr.agreement_id

Line 105: index(pf, PA_PROJECT_FUNDINGS_N4)

101: -- AND NVL(cust.bill_another_project_flag,'N') <> 'Y' -- ER 6519955
102: AND pf.date_allocated is not null
103: union all
104: SELECT /*+ ordered
105: index(pf, PA_PROJECT_FUNDINGS_N4)
106: */
107: p_worker_id WORKER_ID
108: ,nvl(bat.project_org_id, -1) PROJECT_OU_ID
109: ,bat.project_organization_id PROJECT_ORG_ID

Line 121: ,pa_project_fundings pf

117: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
118: ,pf.rowid ROW_ID
119: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
120: FROM pji_fm_proj_batch_map bat
121: ,pa_project_fundings pf
122: ,pa_agreements_all agr
123: ,pa_project_customers cust
124: WHERE l_extraction_type = 'INCREMENTAL'
125: AND pf.agreement_id = agr.agreement_id

Line 155: ,pa_project_fundings pf

151: ,pf.pji_summarized_flag PJI_SUMMARIZED_FLAG
152: ,pf.rowid ROW_ID
153: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
154: FROM pji_fm_proj_batch_map bat
155: ,pa_project_fundings pf
156: ,pa_agreements_all agr
157: ,pa_project_customers cust
158: WHERE l_extraction_type = 'PARTIAL'
159: AND pf.agreement_id = agr.agreement_id

Line 275: update pa_project_fundings

271: if (sql%rowcount <> 0) then
272:
273: commit;
274:
275: update pa_project_fundings
276: set pji_summarized_flag = NULL
277: where rowid in (select /*+ cardinality(fnd, 1) */
278: fnd.row_id
279: from PJI_FM_EXTR_FUNDG fnd