DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_PROJECTS

Line 107: pa_projects pp,

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'
111: AND pcdl.line_type = DECODE(ppt.capital_cost_type_code,'B','D','R')