APPS.RRS_SITE_INFO dependencies on RRS_LOC_TRADE_AREA_GRPS

Line 1297: group_id rrs_loc_trade_area_grps.group_id%TYPE,

1293: l_location_id NUMBER;
1294: l_site_party_id NUMBER;
1295:
1296: TYPE local_rrs_trade_area_grp_rec is RECORD (
1297: group_id rrs_loc_trade_area_grps.group_id%TYPE,
1298: group_name rrs_trade_area_groups_tl.name%TYPE,
1299: group_desc rrs_trade_area_groups_tl.description%TYPE,
1300: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,
1301: status_code rrs_loc_trade_area_grps.status_code%TYPE

Line 1300: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,

1296: TYPE local_rrs_trade_area_grp_rec is RECORD (
1297: group_id rrs_loc_trade_area_grps.group_id%TYPE,
1298: group_name rrs_trade_area_groups_tl.name%TYPE,
1299: group_desc rrs_trade_area_groups_tl.description%TYPE,
1300: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,
1301: status_code rrs_loc_trade_area_grps.status_code%TYPE
1302: );
1303: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;
1304: l_trade_area_groups_details local_rrs_trade_area_grp_tab;

Line 1301: status_code rrs_loc_trade_area_grps.status_code%TYPE

1297: group_id rrs_loc_trade_area_grps.group_id%TYPE,
1298: group_name rrs_trade_area_groups_tl.name%TYPE,
1299: group_desc rrs_trade_area_groups_tl.description%TYPE,
1300: is_primary_flag rrs_loc_trade_area_grps.is_primary_flag%TYPE,
1301: status_code rrs_loc_trade_area_grps.status_code%TYPE
1302: );
1303: TYPE local_rrs_trade_area_grp_tab IS TABLE OF local_rrs_trade_area_grp_rec;
1304: l_trade_area_groups_details local_rrs_trade_area_grp_tab;
1305:

Line 1386: FROM RRS_LOC_TRADE_AREA_GRPS LocTradeAreaGrpsEO

1382: LocTradeAreaGrpsEO.IS_PRIMARY_FLAG,
1383: LocTradeAreaGrpsEO.STATUS_CODE
1384: BULK COLLECT
1385: INTO l_trade_area_groups_details
1386: FROM RRS_LOC_TRADE_AREA_GRPS LocTradeAreaGrpsEO
1387: ,RRS_TRADE_AREA_GROUPS_VL VL
1388: WHERE LocTradeAreaGrpsEO.GROUP_ID = VL.GROUP_ID
1389: AND LOCATION_ID = l_location_id
1390: ORDER BY NAME;