APPS.PA_BILLING_PROCESS_PKG dependencies on PA_TASKS

Line 37: FROM pa_tasks a

33: AND pa_project_utils.check_prj_stus_action_allowed(p.project_status_code,'GENERATE_REV') = 'Y'; /* Added for bug 8887579*/
34: /*
35: CURSOR ctask(cproject_id VARCHAR2) is
36: SELECT *
37: FROM pa_tasks a
38: WHERE project_id=cproject_id
39: AND (
40: (task_id=top_task_id
41: AND ready_to_distribute_flag ='Y'

Line 45: FROM pa_tasks b

41: AND ready_to_distribute_flag ='Y'
42: )
43: OR (chargeable_flag ='Y'
44: AND EXISTS ( SELECT null
45: FROM pa_tasks b
46: WHERE b.task_id = a.top_task_id
47: AND b.ready_to_distribute_flag = 'Y'
48: )
49: )

Line 195: SELECT /*+ INDEX(Rtask PA_TASKS_N8) INDEX(ei PA_EXPENDITURE_ITEMS_N9)*/ 1

191: SELECT 1
192: INTO temp
193: FROM dual
194: WHERE EXISTS(
195: SELECT /*+ INDEX(Rtask PA_TASKS_N8) INDEX(ei PA_EXPENDITURE_ITEMS_N9)*/ 1
196: FROM pa_expenditure_items_all ei,
197: pa_tasks Rtask
198: WHERE Rtask.project_id = Rproj.project_id
199: AND ei.project_id = Rproj.project_id /* 14727962 */

Line 197: pa_tasks Rtask

193: FROM dual
194: WHERE EXISTS(
195: SELECT /*+ INDEX(Rtask PA_TASKS_N8) INDEX(ei PA_EXPENDITURE_ITEMS_N9)*/ 1
196: FROM pa_expenditure_items_all ei,
197: pa_tasks Rtask
198: WHERE Rtask.project_id = Rproj.project_id
199: AND ei.project_id = Rproj.project_id /* 14727962 */
200: AND ei.task_id = Rtask.task_id
201: /*AND Rtask.chargeable_flag = 'Y' Commented for bug 9755401*/

Line 272: pa_tasks Rtask

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
276: AND Rtask.task_id=Rtask.top_task_id