APPS.PA_PURGE_VALIDATE_COSTING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 47: from pa_expenditure_items_all ei

43: select 'NOT COST DISTRIBUTED'
44: from dual
45: where exists (
46: select ei.expenditure_item_id
47: from pa_expenditure_items_all ei
48: where ei.project_id = p_project_id
49: and ( p_active_flag <> 'A'
50: or (trunc(ei.expenditure_item_date ) <=
51: trunc(p_txn_to_date ) ))

Line 73: from pa_expenditure_items_all ei,

69: select 'NOT Transferred and Accepted in other system'
70: from dual
71: where exists (
72: select ei.expenditure_item_id
73: from pa_expenditure_items_all ei,
74: pa_cost_distribution_lines_all cdl
75: where ei.expenditure_item_id = cdl.expenditure_item_id
76: and ei.system_linkage_function not in ('VI', 'ER') /* Bug#2427766 */
77: /* and ei.system_linkage_function <> 'VI' Bug#2616111 */

Line 109: from pa_expenditure_items_all ei,

105: select 'MRC NOT Transferred and Accepted in other system'
106: from dual
107: where exists (
108: select ei.expenditure_item_id
109: from pa_expenditure_items_all ei,
110: pa_mc_cost_dist_lines_all mrccdl
111: where ei.expenditure_item_id = mrccdl.expenditure_item_id
112: and ei.system_linkage_function not in ('VI', 'ER')
113: and ei.project_id = p_project_id

Line 134: from pa_expenditure_items_all ei,

130: select 'Cost not accumulated'
131: from dual
132: where exists (
133: select ei.expenditure_item_id
134: from pa_expenditure_items_all ei,
135: pa_cost_distribution_lines_all cdl
136: where ei.expenditure_item_id = cdl.expenditure_item_id
137: and ei.project_id = p_project_id
138: and ( p_active_flag <> 'A'

Line 149: from pa_expenditure_items_all ei,

145: select 'Not Burden Distributed'
146: from dual
147: where exists (
148: select ei.expenditure_item_id
149: from pa_expenditure_items_all ei,
150: pa_project_types_all pt,
151: pa_tasks t,
152: pa_projects_all p
153: where ei.task_id = t.task_id

Line 172: from pa_expenditure_items_all ei,

168: select 'INTERCOMPANY EIs INV EXISTS'
169: from dual
170: where exists (
171: select ei.expenditure_item_id
172: from pa_expenditure_items_all ei,
173: pa_tasks t
174: where ei.task_id = t.task_id
175: and t.project_id = p_project_id
176: and ei.cc_cross_charge_code = 'I')

Line 188: from pa_expenditure_items_all ei

184: select 'NOT BL DISTRIBUTED'
185: from dual
186: where exists (
187: select ei.expenditure_item_id
188: from pa_expenditure_items_all ei
189: where ei.project_id = p_project_id
190: and ( p_active_flag <> 'A'
191: or trunc(ei.expenditure_item_date) <= trunc(p_txn_to_date) )
192: and ei.cc_cross_charge_code = 'B'

Line 200: from pa_expenditure_items_all ei,

196: select 'NOT Transferred and Accepted in other system'
197: from dual
198: where exists (
199: select ei.expenditure_item_id
200: from pa_expenditure_items_all ei,
201: pa_cc_dist_lines_all ccdl
202: where ei.expenditure_item_id = ccdl.expenditure_item_id
203: and ei.project_id = p_project_id
204: and ( p_active_flag <> 'A'