APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_PROJECT_ASSET_LINE_DETAILS

Line 152: FROM pa_project_asset_line_details pald

148: AND paa.project_asset_id = 0))
149: AND NOT EXISTS
150: (
151: SELECT 'This CDL was summarized before'
152: FROM pa_project_asset_line_details pald
153: WHERE pald.expenditure_item_id = pcdl.expenditure_item_id
154: AND pald.line_num = pcdl.line_num
155: AND pald.reversed_flag||'' = 'N'
156: ));