APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_TASKS

Line 90: pa_tasks pt

86: SELECT 'EI NOT COSTED'
87: FROM dual
88: WHERE EXISTS ( SELECT ei.expenditure_item_id
89: FROM pa_expenditure_items_all ei,
90: pa_tasks pt
91: WHERE ei.system_linkage_function in ( 'VI', 'ER' )
92: AND ei.task_id = pt.task_id
93: AND pt.project_id = p_project_id
94: AND (p_active_flag = 'C' or ei.expenditure_item_date < trunc(p_purge_to_date))

Line 106: pa_tasks pt,

102: FROM dual
103: WHERE EXISTS ( SELECT pcdl.expenditure_item_id
104: FROM pa_cost_distribution_lines_all pcdl,
105: pa_expenditure_items_all pei,
106: pa_tasks pt,
107: pa_projects pp,
108: pa_project_types ppt
109: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
110: AND pei.revenue_distributed_flag||'' = 'N'

Line 121: from pa_tasks pt2

117: trunc(pei.expenditure_item_date) <= trunc(p_purge_to_date))
118: AND pp.project_type = ppt.project_type
119: AND pei.task_id IN
120: ( select task_id
121: from pa_tasks pt2
122: where project_id = pp.project_id
123: and ( exists
124: (SELECT task_id
125: FROM pa_project_asset_assignments paa

Line 137: FROM pa_tasks

133: and task_id = pt2.task_id
134: AND paa.project_asset_id = 0))
135: UNION
136: SELECT task_id
137: FROM pa_tasks
138: WHERE project_id IN
139: (SELECT project_id --- project level asset assignment
140: FROM pa_project_asset_assignments paa
141: WHERE project_id = pp.project_id