DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_PROJECT_ASSET_LINES_ALL

Line 55: FROM pa_project_asset_lines_all pal

51: CURSOR IsAstLinNotXferred IS
52: SELECT 'ASSET LINE NOT TRANSFERRED'
53: FROM dual
54: WHERE EXISTS ( SELECT pal.project_asset_line_id
55: FROM pa_project_asset_lines_all pal
56: WHERE pal.project_id = p_project_id
57: AND pal.transfer_status_code <> 'T');
58:
59: --