APPS.PA_BILLING_PROCESS_PKG dependencies on PA_DRAFT_REVENUES

Line 50: FROM pa_draft_revenues dr

46:
47:
48: CURSOR cdri(cproject_id NUMBER) is
49: SELECT 1
50: FROM pa_draft_revenues dr
51: WHERE dr.project_id = cproject_id
52: AND dr.released_date IS NULL
53: AND dr.generation_error_flag = decode(pmass_gen, 1, 'Y',dr.generation_error_flag);
54:

Line 133: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1

129: AND ei.cost_distributed_flag = 'Y'
130: AND ei.revenue_distributed_flag = 'N'
131: AND ei.expenditure_item_date <= acc_thru_dt
132: AND EXISTS( SELECT NULL
133: FROM pa_cust_rev_dist_lines crdl,pa_draft_revenues drx1
134: WHERE ei.project_id = crdl.project_id
135: AND ((ei.expenditure_item_id = crdl.expenditure_item_id)
136: OR (ei.adjusted_expenditure_item_id IS NOT NULL
137: AND ei.adjusted_expenditure_item_id = crdl.expenditure_item_id))

Line 179: pa_draft_revenues drx

175: EXISTS(
176: SELECT 1
177: FROM pa_events ev,
178: pa_cust_event_rev_dist_lines erdl,
179: pa_draft_revenues drx
180: WHERE ev.project_id = Rtask.project_id
181: AND ev.task_id = Rtask.task_id
182: AND ((ev.revenue_distributed_flag = 'N'
183: AND ev.completion_date <= acc_thru_dt)

Line 235: pa_draft_revenues drx

231: WHERE EXISTS(
232: SELECT 1
233: FROM pa_events ev,
234: pa_cust_event_rev_dist_lines erdl,
235: pa_draft_revenues drx
236: WHERE ev.project_id = Rproj.project_id
237: AND ev.task_id IS NULL
238: AND ((ev.revenue_distributed_flag = 'N'
239: AND ev.completion_date <= acc_thru_dt)