APPS.HZ_CUSTOMER_INT dependencies on HZ_SELECT_DATA_SOURCES

Line 2244: FROM hz_select_data_sources s

2240: SET content_source_type = 'USER_ENTERED',
2241: exception_type = (
2242: SELECT DECODE(sign(s.ranking-p_ue_ranking), 0, exp.exception_type,
2243: 1, 'Migration', -1, 'Exception')
2244: FROM hz_select_data_sources s
2245: WHERE entity_attr_id = p_entity_attr_id
2246: AND content_source_type = exp.content_source_type),
2247: last_updated_by = g_last_updated_by,
2248: last_update_login = g_last_update_login,

Line 2408: hz_select_data_sources s

2404: p_attribute_name VARCHAR2
2405: ) IS
2406: SELECT s.entity_attr_id, s.ranking
2407: FROM hz_entity_attributes e,
2408: hz_select_data_sources s
2409: WHERE e.attribute_name = UPPER(p_attribute_name)
2410: AND e.entity_attr_id = s.entity_attr_id
2411: AND s.content_source_type = 'USER_ENTERED';
2412:

Line 2749: hz_select_data_sources s

2745: p_attribute_name VARCHAR2
2746: ) IS
2747: SELECT s.entity_attr_id, s.ranking
2748: FROM hz_entity_attributes e,
2749: hz_select_data_sources s
2750: WHERE e.attribute_name = UPPER(p_attribute_name)
2751: AND e.entity_attr_id = s.entity_attr_id
2752: AND s.content_source_type = 'USER_ENTERED';
2753: