APPS.FV_SF224_TRANSACTIONS dependencies on FV_ALC_BUSINESS_ACTIVITY_V

Line 640: FROM fv_alc_business_activity_v fa

636: SELECT fa.business_activity_code,
637: fa.gwa_reporter_category_code
638: INTO l_business_activity_code,
639: l_gwa_reporter_category_code
640: FROM fv_alc_business_activity_v fa
641: WHERE fa.set_of_books_id = p_set_of_books_id
642: AND fa.agency_location_code = l_alc_code(i)
643: AND fa.period_name = l_gl_period(i);
644: EXCEPTION

Line 651: l_location := l_module_name||'select_fv_alc_business_activity_v';

647: l_gwa_reporter_category_code := NULL;
648: WHEN OTHERS THEN
649: p_error_code := g_FAILURE;
650: p_error_desc := SQLERRM;
651: l_location := l_module_name||'select_fv_alc_business_activity_v';
652: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
653: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
654: END;
655: END IF;

Line 4612: FROM fv_alc_business_activity_v fv

4608: ELSIF g_partial_or_full ='Partial' THEN
4609: BEGIN
4610: SELECT fv.fv_alc_addresses_id ,fv.business_activity_code, fv.gwa_reporter_category_code
4611: INTO l_alc_addresses_id, l_business_activity_code, l_gwa_reporter_category_code
4612: FROM fv_alc_business_activity_v fv
4613: WHERE fv.agency_location_code = l_alc_code
4614: AND fv.PERIOD_NAME = l_gl_period
4615: AND fv.SET_OF_BOOKS_ID = sob;
4616: EXCEPTION