DBA Data[Home] [Help]

APPS.BIS_PMV_PARAMETERS_PUB dependencies on BIS_AK_CUSTOM_REGIONS

Line 122: FROM ak_customizations customView, bis_ak_custom_regions bookmark

118: ) IS
119:
120: CURSOR c_custom_code_cursor IS
121: SELECT customview.customization_code, customview.customization_application_id
122: FROM ak_customizations customView, bis_ak_custom_regions bookmark
123: WHERE customView.region_code=p_region_code AND
124: customView.region_application_id=p_region_application_id AND
125: customView.customization_code=bookmark.customization_code AND
126: customView.customization_application_id=bookmark.customization_application_id AND

Line 196: delete from BIS_AK_CUSTOM_REGIONS

192: NULL;
193: END IF;
194:
195: -- delete bis region customization
196: delete from BIS_AK_CUSTOM_REGIONS
197: where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
198: and CUSTOMIZATION_CODE = cr.customization_code
199: and REGION_APPLICATION_ID = p_region_application_id
200: and REGION_CODE = p_region_code