APPS.IPA_ASSET_MECH_APIS_PKG dependencies on PA_PROJECT_ASSET_LINES
Line 104: pa_project_asset_lines pal
100: AND (pei.revenue_distributed_flag = 'N' OR
101: (pei.revenue_distributed_flag = 'Y'
102: AND NOT EXISTS (SELECT 'This CDL was summarized before'
103: FROM pa_project_asset_line_details pald, 104: pa_project_asset_lines pal 105: WHERE pald.expenditure_item_id = pei.expenditure_item_id
106: AND pald.project_asset_line_detail_id = pal.project_asset_line_detail_id
107: AND pal.project_asset_id >= 1)
108: )