DBA Data[Home] [Help]

APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_PROJECT_ASSET_LINE_DETAILS

Line 444: FROM pa_project_asset_line_details pald,

440: AND pei.billable_flag ='Y'
441: AND nvl(pei.crl_asset_creation_status_code,'N') <> 'Y'
442: AND not exists (
443: SELECT 'This CDL was summarized before'
444: FROM pa_project_asset_line_details pald,
445: pa_project_asset_lines pal
446: WHERE pald.expenditure_item_id = pei.expenditure_item_id
447: AND pald.project_asset_line_detail_id = pal.project_asset_line_detail_id
448: AND pal.project_asset_id >= 1);