DBA Data[Home] [Help]

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: )