APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_PROJECT_ASSET_LINE_DETAILS

Line 457: FROM pa_project_asset_line_details pald,

453: AND pei.billable_flag ='Y'
454: AND nvl(pei.crl_asset_creation_status_code,'N') <> 'Y'
455: AND not exists (
456: SELECT 'This CDL was summarized before'
457: FROM pa_project_asset_line_details pald,
458: pa_project_asset_lines pal
459: WHERE pald.expenditure_item_id = pei.expenditure_item_id
460: AND pald.project_asset_line_detail_id = pal.project_asset_line_detail_id
461: AND pal.project_asset_id >= 1);