APPS.PA_FAXFACE dependencies on PA_TASKS

Line 1120: pa_tasks

1116: AND paa.task_id =
1117: (SELECT
1118: task_id
1119: FROM
1120: pa_tasks
1121: WHERE
1122: parent_task_id is null --- top task
1123: CONNECT BY task_id = PRIOR parent_task_id
1124: START WITH task_id = x_task_id

Line 1655: pa_tasks pt

1651: FROM
1652: pa_cost_distribution_lines_all pcdl,
1653: pa_expenditure_items_all pei,
1654: pa_expenditure_types pet,
1655: pa_tasks pt
1656: WHERE
1657: pcdl.expenditure_item_id = pei.expenditure_item_id
1658: AND pei.revenue_distributed_flag||'' = 'N'
1659: AND pei.cost_distributed_flag ='Y'

Line 4076: pa_tasks pat

4072: Change done for bug 1280252.
4073: and ( exists (select 'x' -- project has costed,uncapitalized expenditure items
4074: from pa_cost_distribution_lines_all pcdl,
4075: pa_expenditure_items_all pei,
4076: pa_tasks pat
4077: where pcdl.expenditure_item_id = pei.expenditure_item_id
4078: and pei.revenue_distributed_flag||'' = 'N'
4079: and pei.cost_distributed_flag ='Y'
4080: and pcdl.line_type = DECODE(pt.capital_cost_type_code,'R','R','B','D','R')

Line 4377: FROM pa_tasks

4373: INTO v_ret_cost_tasks_exist
4374: FROM sys.dual
4375: WHERE EXISTS
4376: (SELECT task_id
4377: FROM pa_tasks
4378: WHERE project_id = projrec.project_id
4379: AND retirement_cost_flag = 'Y');
4380:
4381: EXCEPTION

Line 4996: pa_tasks pat,

4992: FROM dual
4993: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
4994: FROM pa_cost_distribution_lines_all pcdl,
4995: pa_expenditure_items_all pei,
4996: pa_tasks pat,
4997: pa_projects pp,
4998: pa_project_types pt
4999: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5000: AND pp.project_id = p_project_id

Line 5084: pa_tasks pat,

5080: FROM dual
5081: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5082: FROM pa_cost_distribution_lines_all pcdl,
5083: pa_expenditure_items_all pei,
5084: pa_tasks pat,
5085: pa_projects pp,
5086: pa_project_types pt
5087: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5088: AND pp.project_id = p_project_id

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

5131: FROM dual
5132: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5133: FROM pa_cost_distribution_lines_all pcdl,
5134: pa_expenditure_items_all pei,
5135: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5136: pa_projects_all pp,
5137: pa_project_types pt
5138: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5139: AND pp.project_id = p_project_id

Line 5689: FROM pa_tasks t

5685: AND billable_flag||'' = 'N'
5686: AND capital_event_id IS NULL
5687: AND EXISTS
5688: (SELECT t.task_id
5689: FROM pa_tasks t
5690: WHERE t.task_id = peia.task_id
5691: AND t.retirement_cost_flag = 'Y');
5692:
5693: COMMIT;