DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on RRS_TRADE_AREAS_EXT_VL

Line 1108: from rrs_trade_areas_ext_vl a,rrs_trade_areas b

1104: AND fo.obj_name in ( 'RRS_TRADE_AREA')
1105: AND eoab.attr_group_id = ext.attr_group_id
1106: AND eoab.classification_code IN
1107: ( select b.group_id
1108: from rrs_trade_areas_ext_vl a,rrs_trade_areas b
1109: where b.location_id = l_location_id
1110: and a.trade_area_id = b.trade_area_id
1111: );
1112:

Line 1134: from rrs_trade_areas_ext_vl a

1130: AND DISPLAY_NAME = p_page_name
1131: AND CLASSIFICATION_CODE IN
1132: (
1133: select b.group_id
1134: from rrs_trade_areas_ext_vl a
1135: ,rrs_trade_areas b
1136: where b.location_id = l_location_id
1137: and a.trade_area_id = b.trade_area_id
1138: )