DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on FV_ALC_BUSINESS_ACTIVITY_V

Line 630: FROM fv_alc_business_activity_v fa

626: SELECT fa.business_activity_code,
627: fa.gwa_reporter_category_code
628: INTO l_business_activity_code,
629: l_gwa_reporter_category_code
630: FROM fv_alc_business_activity_v fa
631: WHERE fa.set_of_books_id = p_set_of_books_id
632: AND fa.agency_location_code = l_alc_code(i)
633: AND fa.period_name = l_gl_period(i);
634: EXCEPTION

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

637: l_gwa_reporter_category_code := NULL;
638: WHEN OTHERS THEN
639: p_error_code := g_FAILURE;
640: p_error_desc := SQLERRM;
641: l_location := l_module_name||'select_fv_alc_business_activity_v';
642: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
643: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
644: END;
645: END IF;

Line 4474: FROM fv_alc_business_activity_v fv

4470: ELSIF g_partial_or_full ='Partial' THEN
4471: BEGIN
4472: SELECT fv.fv_alc_addresses_id ,fv.business_activity_code, fv.gwa_reporter_category_code
4473: INTO l_alc_addresses_id, l_business_activity_code, l_gwa_reporter_category_code
4474: FROM fv_alc_business_activity_v fv
4475: WHERE fv.agency_location_code = l_alc_code
4476: AND fv.PERIOD_NAME = l_gl_period
4477: AND fv.SET_OF_BOOKS_ID = sob;
4478: EXCEPTION