APPS.HZ_GNR_PVT dependencies on HZ_GEO_STRUCT_MAP_DTL

Line 1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;

1000:
1001: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
1002: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
1003:
1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1007: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1008: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;

Line 1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;

1001: geo_struct_tbl HZ_GNR_PVT.geo_struct_tbl_type;
1002: geo_suggest_tbl HZ_GNR_PVT.geo_suggest_tbl_type;
1003:
1004: l_geo_rec_tab_col hz_geo_struct_map_dtl.loc_component%TYPE;
1005: l_geo_rec_geo_type hz_geo_struct_map_dtl.geography_type%TYPE;
1006: l_geo_rec_geo_name hz_geographies.geography_name%TYPE;
1007: l_geo_rec_geo_id hz_geographies.geography_id%TYPE;
1008: l_geo_rec_geo_code hz_geographies.geography_code%TYPE;
1009: l_geo_rec_country_code hz_geographies.country_code%TYPE;

Line 4113: ,hz_geo_struct_map_dtl dmap

4109: ll_table_name VARCHAR2)
4110: IS
4111: SELECT dmap.loc_component, dmap.geography_type, dmap.geo_element_col, dmap.loc_seq_num
4112: FROM hz_geo_struct_map smap
4113: ,hz_geo_struct_map_dtl dmap
4114: WHERE smap.address_style = ll_address_style
4115: AND SMAP.country_code = ll_country_code
4116: AND SMAP.loc_tbl_name = ll_table_name
4117: AND smap.map_id = dmap.map_id

Line 4124: ,hz_geo_struct_map_dtl dmap

4120: CURSOR c_full_struct_for_null (ll_country_code VARCHAR2, ll_table_name VARCHAR2)
4121: IS
4122: SELECT dmap.loc_component, dmap.geography_type, dmap.geo_element_col, dmap.loc_seq_num
4123: FROM hz_geo_struct_map smap
4124: ,hz_geo_struct_map_dtl dmap
4125: WHERE smap.address_style IS NULL
4126: AND SMAP.country_code = ll_country_code
4127: AND SMAP.loc_tbl_name = ll_table_name
4128: AND smap.map_id = dmap.map_id

Line 4136: ,hz_geo_struct_map_dtl dmap

4132: ll_table_name VARCHAR2, ll_usage VARCHAR2)
4133: IS
4134: SELECT haud.geography_type
4135: FROM hz_geo_struct_map smap
4136: ,hz_geo_struct_map_dtl dmap
4137: ,hz_address_usages hau
4138: ,hz_address_usage_dtls haud
4139: WHERE smap.address_style = ll_address_style
4140: AND SMAP.country_code = ll_country_code

Line 4155: ,hz_geo_struct_map_dtl dmap

4151: ll_table_name VARCHAR2, ll_usage VARCHAR2)
4152: IS
4153: SELECT haud.geography_type
4154: FROM hz_geo_struct_map smap
4155: ,hz_geo_struct_map_dtl dmap
4156: ,hz_address_usages hau
4157: ,hz_address_usage_dtls haud
4158: WHERE smap.address_style IS NULL
4159: AND SMAP.country_code = ll_country_code