APPS.PA_BILLING_PROCESS_PKG dependencies on PA_DRAFT_REVENUES

Line 61: FROM pa_draft_revenues dr

57:
58:
59: CURSOR cdri(cproject_id NUMBER) is
60: SELECT 1
61: FROM pa_draft_revenues dr
62: WHERE dr.project_id = cproject_id
63: AND dr.released_date IS NULL
64: AND dr.generation_error_flag = decode(pmass_gen, 1, 'Y',dr.generation_error_flag);
65:

Line 211: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1

207: AND ei.cost_distributed_flag = 'Y'
208: AND ei.revenue_distributed_flag = 'N'
209: AND ei.expenditure_item_date <= acc_thru_dt
210: AND EXISTS( SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL
211: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1
212: WHERE ei.project_id = crdl.project_id
213: AND (ei.expenditure_item_id = crdl.expenditure_item_id) /* 14727962 */
214: AND NVL(crdl.reversed_flag,'N') = 'N'
215: AND NVL(crdl.line_num_reversed,0) = 0

Line 223: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1

219: = DECODE(drx1.released_date,NULL,1,0)
220: /* 14727962 */
221: UNION ALL
222: SELECT /*+ INDEX(crdl PA_CUST_REV_DIST_LINES_U1)*/ NULL
223: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1
224: WHERE ei.project_id = crdl.project_id
225: AND (ei.adjusted_expenditure_item_id IS NOT NULL
226: AND ei.adjusted_expenditure_item_id = crdl.expenditure_item_id)
227: AND NVL(crdl.reversed_flag,'N') = 'N'

Line 271: pa_draft_revenues drx,

267: EXISTS(
268: SELECT 1
269: FROM pa_events ev,
270: pa_cust_event_rev_dist_lines erdl,
271: pa_draft_revenues drx,
272: pa_tasks Rtask
273: WHERE ev.project_id = Rtask.project_id
274: AND ev.task_id = Rtask.task_id
275: AND Rtask.project_id = Rproj.project_id

Line 331: pa_draft_revenues drx

327: WHERE EXISTS(
328: SELECT 1
329: FROM pa_events ev,
330: pa_cust_event_rev_dist_lines erdl,
331: pa_draft_revenues drx
332: WHERE ev.project_id = Rproj.project_id
333: AND ev.task_id IS NULL
334: AND ((ev.revenue_distributed_flag = 'N'
335: AND ev.completion_date <= acc_thru_dt)