DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_COSTING dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 74: pa_cost_distribution_lines_all cdl

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 */
78: and ei.project_id = p_project_id

Line 135: pa_cost_distribution_lines_all cdl

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'
139: or (trunc(ei.expenditure_item_date ) <=