APPS.AMS_LIST_SRC_FIELD_PVT dependencies on AMS_LIST_SRC_TYPE_ASSOCS

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 1019: FROM ams_list_src_type_assocs

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

Line 1034: -- FROM ams_list_src_type_assocs

1030: -- WHERE
1031: -- (list_source_type_id=p_list_src_field_rec.list_source_type_id
1032: -- OR list_source_type_id IN
1033: -- ( SELECT sub_source_type_id
1034: -- FROM ams_list_src_type_assocs
1035: -- WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id
1036: -- OR sub_source_type_id = p_list_src_field_rec.list_source_type_id)
1037: -- AND enabled_flag = 'Y'
1038: -- )

Line 1052: FROM ams_list_src_type_assocs

1048: SELECT *
1049: FROM ams_list_src_fields_vl
1050: WHERE list_source_type_id IN
1051: ( SELECT sub_source_type_id
1052: FROM ams_list_src_type_assocs
1053: WHERE ( master_source_type_id = p_list_src_field_rec.list_source_type_id
1054: OR sub_source_type_id = p_list_src_field_rec.list_source_type_id)
1055: AND enabled_flag = 'Y'
1056: )