APPS.PA_BILLING_PROCESS_PKG dependencies on PA_TASKS

Line 26: FROM pa_tasks a

22: AND t.project_type_class_code = 'CONTRACT';
23:
24: CURSOR ctask(cproject_id VARCHAR2) is
25: SELECT *
26: FROM pa_tasks a
27: WHERE project_id=cproject_id
28: AND (
29: (task_id=top_task_id
30: AND ready_to_distribute_flag ='Y'

Line 34: FROM pa_tasks b

30: AND ready_to_distribute_flag ='Y'
31: )
32: OR (chargeable_flag ='Y'
33: AND EXISTS ( SELECT null
34: FROM pa_tasks b
35: WHERE b.task_id = a.top_task_id
36: AND b.ready_to_distribute_flag = 'Y'
37: )
38: )