DBA Data[Home] [Help]

APPS.IPA_ASSET_MECH_APIS_PKG dependencies on PA_PROJECT_ASSET_LINE_DETAILS

Line 103: FROM pa_project_asset_line_details pald,

99: /* Added for Bug 3574567 */
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)