DBA Data[Home] [Help]

APPS.ZX_GEO_JUR_MIGR_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 70: FROM fnd_segment_attribute_values seg, ar_system_parameters_all sys

66: PROCEDURE CREATE_GEO_TYPE IS
67:
68: CURSOR geo_type IS
69: SELECT segment_attribute_type
70: FROM fnd_segment_attribute_values seg, ar_system_parameters_all sys
71: WHERE seg.id_flex_code = 'RLOC'
72: AND seg.id_flex_num = sys.location_structure_id
73: AND seg.attribute_value = 'Y'
74: AND segment_attribute_type NOT IN ('TAX_ACCOUNT', 'EXEMPT_LEVEL')

Line 145: FROM fnd_id_flex_structures struct, fnd_id_flex_segments_vl seg, fnd_segment_attribute_values attr,

141: geo.geography_id
142: BULK COLLECT INTO
143: l_location_structure_id_tbl, l_country_code_tbl,
144: l_segment_attribute_type_tbl, l_geography_id_tbl
145: FROM fnd_id_flex_structures struct, fnd_id_flex_segments_vl seg, fnd_segment_attribute_values attr,
146: ar_system_parameters_all sys, hz_geographies geo
147: WHERE struct.application_id = seg.application_id
148: AND struct.id_flex_code = seg.id_flex_code
149: AND struct.id_flex_num = seg.id_flex_num