APPS.FII_SIZING_UTIL dependencies on PA_TASKS

Line 141: from pa_tasks pt

137: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
138: cursor c_cnt_rows IS
139: select sum(cnt) from (
140: SELECT count(*) cnt
141: from pa_tasks pt
142: WHERE (NOT EXISTS
143: (select '*' from pa_tasks
144: where parent_task_id = pt.task_id)
145: OR pt.parent_task_id IS NULL )

Line 143: (select '*' from pa_tasks

139: select sum(cnt) from (
140: SELECT count(*) cnt
141: from pa_tasks pt
142: WHERE (NOT EXISTS
143: (select '*' from pa_tasks
144: where parent_task_id = pt.task_id)
145: OR pt.parent_task_id IS NULL )
146: AND pt.last_update_date BETWEEN p_from_date AND p_to_date
147: UNION