APPS.AMS_LIST_SRC_FIELD_PVT dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 972: -- FROM ams_list_src_type_assocs

968: -- WHERE
969: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
970: -- OR list_source_type_id IN
971: -- ( SELECT sub_source_type_id
972: -- FROM ams_list_src_type_assocs
973: -- WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id
974: -- OR sub_source_type_id = p_list_src_field_rec.list_source_type_id)
975: -- AND enabled_flag = 'Y'
976: -- )

Line 988: FROM ams_list_src_type_assocs

984: SELECT *
985: FROM ams_list_src_fields_vl
986: WHERE list_source_type_id IN
987: ( SELECT sub_source_type_id
988: FROM ams_list_src_type_assocs
989: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id
990: OR sub_source_type_id = p_list_src_field_rec.list_source_type_id)
991: AND enabled_flag = 'Y'
992: )

Line 1003: -- FROM ams_list_src_type_assocs

999: -- WHERE
1000: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
1001: -- OR list_source_type_id IN
1002: -- ( SELECT sub_source_type_id
1003: -- FROM ams_list_src_type_assocs
1004: -- WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id
1005: -- OR sub_source_type_id = p_list_src_field_rec.list_source_type_id)
1006: -- AND enabled_flag = 'Y'
1007: -- )

Line 1021: FROM ams_list_src_type_assocs

1017: SELECT *
1018: FROM ams_list_src_fields_vl
1019: WHERE list_source_type_id IN
1020: ( SELECT sub_source_type_id
1021: FROM ams_list_src_type_assocs
1022: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id
1023: OR sub_source_type_id = p_list_src_field_rec.list_source_type_id)
1024: AND enabled_flag = 'Y'
1025: )