APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_BUS_OBJ_DEFINITIONS

Line 4017: FROM hz_bus_obj_definitions d

4013: ) IS
4014: CURSOR get_bus_obj(l_bus_obj VARCHAR2) IS
4015: SELECT d.business_object_code, d.child_bo_code, d.tca_mandated_flag,
4016: d.user_mandated_flag, d.root_node_flag, d.entity_name
4017: FROM hz_bus_obj_definitions d
4018: start with d.business_object_code = l_bus_obj and d.user_mandated_flag = 'Y'
4019: connect by prior d.child_bo_code = d.business_object_code and d.user_mandated_flag = 'Y'
4020: group by d.business_object_code, d.child_bo_code, d.tca_mandated_flag,
4021: d.user_mandated_flag, d.root_node_flag, d.entity_name;

Line 4073: FROM hz_bus_obj_definitions d

4069: l_telex VARCHAR2, l_web VARCHAR2, l_edi VARCHAR2,
4070: l_eft VARCHAR2, l_sms VARCHAR2) IS
4071: SELECT d.business_object_code, d.child_bo_code, d.tca_mandated_flag,
4072: d.user_mandated_flag, d.root_node_flag, d.entity_name
4073: FROM hz_bus_obj_definitions d
4074: start with d.business_object_code in (l_phone, l_email, l_telex, l_web, l_edi, l_eft, l_sms) and d.user_mandated_flag = 'Y'
4075: connect by prior d.child_bo_code = d.business_object_code
4076: and d.user_mandated_flag = 'Y'
4077: group by d.business_object_code, d.child_bo_code, d.tca_mandated_flag,