APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 170: Cursor C_Mapping_SubTypes(p_master_source_type_id ams_list_src_type_assocs.master_source_type_id%type)

166: Where master_source_type_flag = 'Y'
167: And list_source_type = 'TARGET';
168:
169: --Getting the set of sub types associated with a master type.
170: Cursor C_Mapping_SubTypes(p_master_source_type_id ams_list_src_type_assocs.master_source_type_id%type)
171: IS Select source_type_code
172: From ams_list_src_types a,
173: ams_list_src_type_assocs b
174: Where b.master_source_type_id = p_master_source_type_id

Line 173: ams_list_src_type_assocs b

169: --Getting the set of sub types associated with a master type.
170: Cursor C_Mapping_SubTypes(p_master_source_type_id ams_list_src_type_assocs.master_source_type_id%type)
171: IS Select source_type_code
172: From ams_list_src_types a,
173: ams_list_src_type_assocs b
174: Where b.master_source_type_id = p_master_source_type_id
175: And b.sub_source_type_id = a.list_source_type_id;
176:
177: