APPS.PA_FAXFACE dependencies on PA_TASKS

Line 1178: pa_tasks

1174: AND paa.task_id =
1175: (SELECT
1176: task_id
1177: FROM
1178: pa_tasks
1179: WHERE
1180: parent_task_id is null --- top task
1181: CONNECT BY task_id = PRIOR parent_task_id
1182: START WITH task_id = x_task_id

Line 1859: pa_tasks pt

1855: FROM
1856: pa_cost_distribution_lines_all pcdl,
1857: pa_expenditure_items_all pei,
1858: pa_expenditure_types pet,
1859: pa_tasks pt
1860: WHERE
1861: pcdl.expenditure_item_id = pei.expenditure_item_id
1862: AND pei.revenue_distributed_flag||'' = 'N'
1863: AND pei.cost_distributed_flag ='Y'

Line 4460: pa_tasks pat

4456: Change done for bug 1280252.
4457: and ( exists (select 'x' -- project has costed,uncapitalized expenditure items
4458: from pa_cost_distribution_lines_all pcdl,
4459: pa_expenditure_items_all pei,
4460: pa_tasks pat
4461: where pcdl.expenditure_item_id = pei.expenditure_item_id
4462: and pei.revenue_distributed_flag||'' = 'N'
4463: and pei.cost_distributed_flag ='Y'
4464: and pcdl.line_type = DECODE(pt.capital_cost_type_code,'R','R','B','D','R')

Line 4763: FROM pa_tasks

4759: INTO v_ret_cost_tasks_exist
4760: FROM sys.dual
4761: WHERE EXISTS
4762: (SELECT task_id
4763: FROM pa_tasks
4764: WHERE project_id = projrec.project_id
4765: AND retirement_cost_flag = 'Y');
4766:
4767: EXCEPTION

Line 5382: pa_tasks pat,

5378: FROM dual
5379: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5380: FROM pa_cost_distribution_lines_all pcdl,
5381: pa_expenditure_items_all pei,
5382: pa_tasks pat,
5383: pa_projects pp,
5384: pa_project_types pt
5385: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5386: AND pp.project_id = p_project_id

Line 5470: pa_tasks pat,

5466: FROM dual
5467: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5468: FROM pa_cost_distribution_lines_all pcdl,
5469: pa_expenditure_items_all pei,
5470: pa_tasks pat,
5471: pa_projects pp,
5472: pa_project_types pt
5473: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5474: AND pp.project_id = p_project_id

Line 5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */

5517: FROM dual
5518: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5519: FROM pa_cost_distribution_lines_all pcdl,
5520: pa_expenditure_items_all pei,
5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5522: pa_projects_all pp,
5523: pa_project_types pt
5524: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5525: AND pp.project_id = p_project_id

Line 6108: FROM pa_tasks t

6104: AND billable_flag||'' = 'N'
6105: AND capital_event_id IS NULL
6106: AND EXISTS
6107: (SELECT t.task_id
6108: FROM pa_tasks t
6109: WHERE t.task_id = peia.task_id
6110: AND t.retirement_cost_flag = 'Y');
6111:
6112: COMMIT;